macros on password protectd files

J

Jim

Just got RTM excel 2007.
Looks like there is no way to enable macros on a xslm file if it has a
password on it.

To recreate:
Create a new workbook with a simple macro. Save it with a password.
Open it. No way to run macros. (regardless of trust settings).
Save it without a password. Open it. macros work as expected.
 
J

Jim

On another thread I was told:
"There is a registry entry to
turn this off though.

Create this key and set its value to 1:

ExcelBypassEncryptedMacroScan

under:

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

I haven't tested this yet. From the name of the registry entry, I wonder if:
a) excel does a virus scan on macros before opening
b) it can't do than on pw protected files, so it won't allow them to open.
if that's the case, it's pretty lazy of them to not just do this correctly,
and do the scan after the password is given.
 
Top