passwords incompatible with macros in 2007?
Security everywhere... I feel so safe.<g 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\E xcel\Security
--
Jim
"Jim" wrote in message
...
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.
|