ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I enblae macros in a password protected workbook? (https://www.excelbanter.com/excel-programming/389318-how-do-i-enblae-macros-password-protected-workbook.html)

Tevuna

How do I enblae macros in a password protected workbook?
 
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?

Tevuna

How do I enblae macros in a password protected workbook?
 
Now I found the answer written by Jim Rech under "Exce. Misc"
A little tinkering with the registry solves the problem.

"Tevuna" wrote:

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?



All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com