Re: $$Excel-Macros$$ Password protect & unprotect sheets using code

Hi, Thanks for ur reply Regards Rajesh Kainikkara On 4/15/11, STDEV(i) wrote: > Sub ABCD() > Sheets("MySheet").Unprotect "yourpassword" > --- your program accessing to sheets("MySheet") > Sheets("MySheet").Protect "yourpassword" > End sub > > > On Fri, Apr 15, 2011 at 6:51 PM, Rajesh K R > wr

Re: $$Excel-Macros$$ Password protect & unprotect sheets using code

Please send excel file. On Fri, Apr 15, 2011 at 5:21 PM, Rajesh K R wrote: > Hi Experts, > > I want to password protect my work sheets, but the same time it is > necessary to unprotect it for the running of macro so i have to give a > code to unprotect them. how can I do it. > > Regards > > Rajes

Re: $$Excel-Macros$$ Password protect & unprotect sheets using code

Sub ABCD() Sheets("MySheet").Unprotect "yourpassword" --- your program accessing to sheets("MySheet") Sheets("MySheet").Protect "yourpassword" End sub On Fri, Apr 15, 2011 at 6:51 PM, Rajesh K R wrote: > Hi Experts, > I want to password protect my work sheets, but the same time it is > necessar

$$Excel-Macros$$ Password protect & unprotect sheets using code

Hi Experts, I want to password protect my work sheets, but the same time it is necessary to unprotect it for the running of macro so i have to give a code to unprotect them. how can I do it. Regards Rajesh kainikkara -- --