![]() |
Running macros with protect workbooks
Hello, I created a workbook that have hidden worksheets, with data that I do
not want to disclose, thus I have hidden those worksheets and protected the workbook. However, since the workbook has macros, everytime that I open the file, Macros are disabled and there is no option to run the macros. Excel says that I need to remove the encryption to run the macros. The Macro security is set to low. I am using Excel 2007. Can you please help me? Thanks -- Dude |
Running macros with protect workbooks
You may have to save the workbook in Excel 97-2003 format.
-- Jim "Duderino" wrote in message ... | Hello, I created a workbook that have hidden worksheets, with data that I do | not want to disclose, thus I have hidden those worksheets and protected the | workbook. | However, since the workbook has macros, everytime that I open the file, | Macros are disabled and there is no option to run the macros. Excel says that | I need to remove the encryption to run the macros. | The Macro security is set to low. I am using Excel 2007. | Can you please help me? | Thanks | -- | Dude |
All times are GMT +1. The time now is 11:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com