Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When saving, Excel prompt me for all worksheet passwords
Hello,
I have protected the 20 worksheets of a workbook with a password. When I save the file (or Save As), it prompts 20 times for the password (Prompt "Unprotect Worksheet"). 1st case: I enter 20 times the password and close the file. When I open the file again, the 20 worksheets are still protected but without a password. 2nd case: I click 20 times on "Cancel", it works but each time a user saves the file, he should click 20 times on "Cancel". How could I save the file without it asks me for the password? Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When saving, Excel prompt me for all worksheet passwords
This is not normal behaviour.
Do you have any code like BeforeSave or BeforeClose event in Thisworkbook? BTW..........which version of Excel? I'm not conversant with the workings of 2007 version. Gord Dibben MS Excel MVP On Wed, 9 Jul 2008 03:44:00 -0700, Tzardos wrote: Hello, I have protected the 20 worksheets of a workbook with a password. When I save the file (or Save As), it prompts 20 times for the password (Prompt "Unprotect Worksheet"). 1st case: I enter 20 times the password and close the file. When I open the file again, the 20 worksheets are still protected but without a password. 2nd case: I click 20 times on "Cancel", it works but each time a user saves the file, he should click 20 times on "Cancel". How could I save the file without it asks me for the password? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no prompt for saving after making changes | Excel Discussion (Misc queries) | |||
Saving database access log in and passwords | Excel Discussion (Misc queries) | |||
How do I get rid of prompt when saving Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
template for saving passwords | Excel Discussion (Misc queries) | |||
template for saving passwords | Excel Discussion (Misc queries) |