Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: Macros disabled when workbook is protected (why?)
MS has provided this information:
http://support.microsoft.com/kb/927150/en-us -- Jim "Felipe" wrote in message ... | Hi, | I'm running into the following situation wich seems to present a different | behaviour in Excel 2007 than in 2003 and one that I can't understand. I will | appreciate any help or comments. | | Macro Security = "Disable all macros with notification". | | When opening a workbook (.xlsm) with a macro included on it, the message | bar correctly shows me the "Security Warning: Macros have been disabled" | message, and offers me the option to "Enable this Content" when clicking on | the Options... button. | | After protecting the same workbook with the Protect Workbook feature and | opening the file again, the same message is shown in the message bar but the | "Enable this Content" option is not available in the dialog opened with the | Options... button and the following message is shown on the same dialog: | | "This file contains encrypted macros that have been disabled because there | is no antivirus software installed that can scan them. To run these macros, | remove the encryption or permission restrictions on the file." | | Any comments on why the Protect Worksheet is interfering with the macro | security? I haven't found a way to enable the macros without unprotecting the | workbook. I've test this with a very simple sample workbook. | | Thanks, | Felipe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unprotect (in Excel 2007) workbook created and protected in Excel | New Users to Excel | |||
Excel 2007 - Encrypted and password protected Workbook | New Users to Excel | |||
When workbook is reopened, macros are disabled | Excel Programming | |||
Workbook opened with macros disabled | Excel Programming | |||
Excel crashes when attempting to open workbook...even with macros disabled | Excel Programming |