Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel unprotect all my sheets when I hit save?
I have protected several sheets in an Excel workbook and in each case have
set a password without which users shouldn't be able to unprotect. But when I try to save the file, Excel for some reason comes up with a prompt asking me to enter a password to "Unprotect Sheet". Whatever I do at this point (either enter a password or click cancel), the workbook will save and the worksheet will still be protected but it's no longer password-protected, which I really need it to be! Any help on fixing this would be much appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Excel unprotect all my sheets when I hit save?
It sounds like you have a "helpful" macro jumping in where it doesn't belong.
I'd try opening that workbook with macros disabled to see if the save worked normally. If it did, then contact the developer to find out why he or she did that. If you were the developer, look for a workbook_beforesave procedure in the ThisWorkbook module inside the VBE (at least start there). lpyrrm wrote: I have protected several sheets in an Excel workbook and in each case have set a password without which users shouldn't be able to unprotect. But when I try to save the file, Excel for some reason comes up with a prompt asking me to enter a password to "Unprotect Sheet". Whatever I do at this point (either enter a password or click cancel), the workbook will save and the worksheet will still be protected but it's no longer password-protected, which I really need it to be! Any help on fixing this would be much appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can we unprotect a Excel sheet having password by Save as Option . | Excel Worksheet Functions | |||
Protect/unprotect all sheets at once? | New Users to Excel | |||
Protect-Unprotect all the sheets | Excel Worksheet Functions | |||
unprotect sheets | Excel Worksheet Functions | |||
Unprotect Sheets | Excel Worksheet Functions |