Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I accidentally used the following code in some VBA to protect my worksheet:
ActiveSheet.Protect Password = "grencr" (I excluded the colon) I should have used: ActiveSheet.Unprotect Password:="grencr". The code worked and my worksheet is now protected, but I'm not sure what the password is. It is no longer grencr. Any idea what my password was set to since I didn't include the : in the code? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
protect worksheet | Excel Discussion (Misc queries) | |||
worksheet protect | Excel Worksheet Functions | |||
How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
Protect worksheet | Excel Programming |