ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Running macros with protect workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/139394-running-macros-protect-workbooks.html)

Duderino

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

Jim Rech

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