Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Workbook
I have code that calls a workbook that I once protected,
but cannot get it to save as unprotected. Now, when the macro calls this workbook to open, I get prompted for the password. How do I get this workbook to save as unprotected so I don't have to enter a password 100 times (yes, I went to Tools\Protection\Protect Workbook\Unprotect Workbook\Save)? TIA!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Workbook
Hi
Try this: In the file menu, go to Save As.. In the dialog box across the top you will see a menu called Tools. Select General Options.. There may be a password hiding in this bit - simply remove it. Regards Andrew B "JEFFRO" wrote in message ... I have code that calls a workbook that I once protected, but cannot get it to save as unprotected. Now, when the macro calls this workbook to open, I get prompted for the password. How do I get this workbook to save as unprotected so I don't have to enter a password 100 times (yes, I went to Tools\Protection\Protect Workbook\Unprotect Workbook\Save)? TIA!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protected workbook | Excel Discussion (Misc queries) | |||
password protected workbook | Excel Worksheet Functions | |||
Protected Workbook | Excel Discussion (Misc queries) | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |