Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Macros | Links and Linking in Excel | |||
Running Macros | Excel Discussion (Misc queries) | |||
Running Macros | Excel Worksheet Functions | |||
Running Macros when on the LAN | Excel Discussion (Misc queries) | |||
HELP - Running Macros in VBA | New Users to Excel |