View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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