Running macros with protect workbooks

G

Guest

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
 
J

Jim Rech

You may have to save the workbook in Excel 97-2003 format.

--
Jim
| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with macros and protections 5
How to protect macro cointained Worksheets and workbooks by using 6
Run Macros in a Password-protected workbook? 1
Excel Macro Warning problems 1
Macro Help 1
problem with macro setting 1
Move/Copy Worksheet with Macros 2
Excel 2007 enabling macros 3

Top