Enable Macros Office 2007

[Abdul]

How to enable macros in a protected workbook under Office 2007

I tried one of the bypass posted here but not getting it to work?!!

I am using Windows XP, Office 2007, Mcafee Virus Scan Enterpris 8.

Create this key and set its value to 1:

ExcelBypassEncryptedMacroScan

under:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security

Thanks,

Abdul

 

[Guest]

Hi,

If what you are asking is how can you run a macro which would change part of
a protected workbook, then you have at least two options:

1. turn off protection within the code and turn it back on in the code.
2. turn protection on in code and use the UserInterfaceOnly:=True option.

This option allows the macro to run against a protected workbook and to
modify it despite the fact that the sheet is protected. Look this up in help
if you need to understand more.