PDA

Click to See Complete Forum and Search --> : protect method in excel


vb_student
Jan 19th, 2005, 10:42 AM
Hello
I found this line in my code, i tried looking at the properties online but MS does not give a good description. can you guys tell me whether this line of code ensures that i cannot open the worksheet anywehere else but in excel?

myFile.Worksheets("mysheet").protect DrawingObjects:=True, Contents:=True, Scenarios:=True

RobDog888
Jan 19th, 2005, 11:01 AM
If you look up Protect in the Excel help file you will find a good explaination.
Basically if you do not supply a password when protecting it, you can just
call the Unprotect method to make it editable, either through code or in the
UI menu.

HTH