Excel 2007 Macros Do Not Run

[trussman2]

I created a spreadsheet that has a series of worksheets. On the first one I placed a number of buttons to jump to the appropriate worksheet that you need. Now I cannot access these macros. I keep getting a message saying the security setting does not allow macros to run. I changed my settings to Enable All Macros, and they still do not run.

I prefer the old Excel that would ask if you want them enabled or not.

Any help is greatly appreciated.

Thank you.

 

[xlhelp]

If workbook is saved with encryption (Office menu, Prepare, Encrypt Document) or if on the Review tab, Protect Workbook, Protect Structure is selected, and a
password is supplied, macros do not run


Member- AAAA Association Against Acronym Abusers

 

[trussman2]

Oh ok. Well that is ridiculous. This is a spreadsheet that we will share with our customers. I don't want them to be changing information.

Is there any way to protect the formulas and information, yet still have the macros run?

Thanks!!

 

[xlhelp]

Protect sheet does not block macros, it's only protected workbooks.


There is a regkey that's supposed to fix it. I have not tried it.

HKCU\Software\Microsoft\Office\12.0\Excel\Security

you would need to add a new DWORD
ExcelBypassEncryptedMacroScan
and set the value to 1

Warning! Achtung! Danger! If you do not know how to deal with regkeys, it can really mess up your system

Vita Brevis

 

[Rofeu]

Hi,

there's a checkbox in the security on the tab 'Trusted Sources' with something like 'Trust access to VB Projects'. That also needs to be checked.

Cheers,

Roel

 

[trussman2]

Well I cannot ask everyone that uses this program to change their registry.

I have tried checking that box on the Excel option settings. That still doesn't work.

I understand Macros can be dangerous and it is a good policy to protect against them. But like I said, in the older versions of Excel, it always asked if you wanted to run them or not.

I will have to work on some other way to protect this.

 

[trussman2]

I just wanted to thank everyone for their help. I think it was extremely dumb for MS to remove the feature that asked if you want Macros to run.

Thanks again.