View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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.