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 > >