Running macros with protect workbooks

D

Duderino

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

Need Help with Macro Security 1
Enabling Macros message when NO macros in workbook 3
Run Macros in a Password-protected workbook? 1
problem with macros and protections 5
Spell Check Protected WORKBOOK 1
Disable Macro Alert 2
Right Click Options Greyed out....Sheet is not protected 1
Excel 2007: Creating a macro that will run Solver. 0

Top