How do I enblae macros in a password protected workbook?

G

Guest

In Excel 2007, If a workbook is password protected, macros are disabled, even
if the workbook is located in a trusted location, and even if the correct
password is entered. Is there a way to enable all macros?
 
G

Guest

Now I found the answer written by Jim Rech under "Exce. Misc"
A little tinkering with the registry solves the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Unlock Excel Workbook protected by MACRO Password 6
Excel Protection 2
Excel 2007: Macros not working in password-protected workbooks 2
Runtime error 424 in Windows 8 environment 15
Best Practices - Workbook security & macros 2
Setting up Solver reference in a protected VBA project 1
Excel 2007 Macro Security 2
Macros disabled, not by security settings? 5

Top