Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet

2009-11-13 Thread Paul Schreiner
ion = xlUnlockedCells End Sub Sub Protect_with_Password()     ActiveSheet.Unprotect     ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="unlockplease" End Sub Paul From: Aindril De To: excel-macros@googlegroups.com S

Re: $$Excel-Macros$$ Macro to Protect cell of a worksheet

2009-11-13 Thread Aindril De
Debashish, Could you please elaborate the requirement. If possible with an example workbook. Regards, Andy On Fri, Nov 13, 2009 at 5:03 PM, DEBASHIS BANERJEE wrote: > > Dear Friend, > > I need a Macro to Protect Cell of a work Sheet . Kindly help . it is > Urgent . > > Thanks and regards > >

$$Excel-Macros$$ Macro to Protect cell of a worksheet

2009-11-13 Thread DEBASHIS BANERJEE
Dear Friend, I need a Macro to Protect Cell of a work Sheet . Kindly help . it is Urgent . Thanks and regards Debashis. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Fre