Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.Protect Question
Hi there,
I was experimenting with ActiveSheet.Protect function and ran the following piece of code: ActiveSheet.Protect True , True then I was happy that the sheet was locked but when I tried to run: ActiveSheet.Protect False,False to unlock the sheet got the message saying wrong password. Now I can't unlock it. Do you know the exact syntacs of the command? I tried several passwords (thought that "True" was the pasword parameter)... but nothing helped. Is there any default pasword? Sounds silly but any idea? Cheers Dusan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.Protect Question
You gave the workbook the password boolean True, so you can
unprotect with activesheet.unprotect true You can also remove worksheet protection in a few heartbeats. See http://www.mcgimpsey.com/excel/removepwords.html In article , (Dusan) wrote: Hi there, I was experimenting with ActiveSheet.Protect function and ran the following piece of code: ActiveSheet.Protect True , True then I was happy that the sheet was locked but when I tried to run: ActiveSheet.Protect False,False to unlock the sheet got the message saying wrong password. Now I can't unlock it. Do you know the exact syntacs of the command? I tried several passwords (thought that "True" was the pasword parameter)... but nothing helped. Is there any default pasword? Sounds silly but any idea? Cheers Dusan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet.Protect Question
Dusan,
I thought the syntax was "Activesheet.protect(password)" and "Activesheet.unprotect(password)". Maybe you're using a different version, or maybe this is the problem. Also, it might be interpreting the password as the logical value True when you lock it, and then interpreting it as the string "True" when you try to unlock it. Maybe try the password = 1 (the value of TRUE)? Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cells Question | Excel Discussion (Misc queries) | |||
Share Workbook/Protect Sheet Question | Excel Discussion (Misc queries) | |||
How can i protect worksheet until a value is placed in a certain c | Excel Discussion (Misc queries) | |||
protect the worksheet | Excel Worksheet Functions | |||
How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) |