macros on password protectd files

[Guest]

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.

 

[Moses Masenda]

I tested this as well and it appears to be a bug to me. I will see what I can find on this one. Check this post for updates.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Guest]

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.