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!!!! |
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!!!! |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com