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\E xcel\Security



Thanks,

Abdul

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.
--
Cheers,
Shane Devenshire


"Abdul" wrote:

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\E xcel\Security



Thanks,

Abdul