Macros are disabled when you open password protected workbooks

Posted on January 9, 2008 by Ron de Bruin

Hi all

If you have the problem above in Excel 2007 read this page
http://www.rondebruin.nl/password2007.htm

It seems that not all machines have this problem.
I have two Vista machines that will run the code without adding the DWORD.
Very strange and I really like to know why.

Ron de Bruin
http://www.rondebruin.nl/tips.htm

9 thoughts on “Macros are disabled when you open password protected workbooks”

Dennis Wallentin says:

January 9, 2008 at 8:04 am

Hi Ron,

Ron,

Thanks for posting this info & tip :)

In my “world” of managed COM Add-ins I face some “mysterious” like this one http://xldennis.wordpress.com/2007/12/26/excel-2003-windows-vista-bug/.

We would be better of if the mysterious existed on every computer and not randomly as it is now…

I wonder if the upcoming SP-1 will give us a more better situation with Vista.

Kind regards,
Dennis
Ron de Bruin says:

January 9, 2008 at 9:20 am

hi Dennis

>I wonder if the upcoming SP-1 will give us a more better situation with Vista.

I hope that it will fix a few strange things
jkpieterse says:

January 9, 2008 at 12:34 pm

Hi Ron,

Good to know a fix. The problem also occurs when the workbook protection password is set (not the file open password). Not sure which password your example refers to.
Ron de Bruin says:

January 9, 2008 at 2:38 pm

Hi JK

>file open password

But you are right that you have the same problem with workbook protection.
I will make this clear on this page
Ron de Bruin says:

January 10, 2008 at 1:37 pm

I add a reg file to my page today.
If you open this file it will add the DWORD to the register for you.

Thanks for the suggestion Dennis.
Harald Staff says:

January 11, 2008 at 5:07 am

Unfortunately then registry key in mention never worked for me, I struggled with this for days. We are not able to have password protected xlsm files at the moment. I have no idea what goes on.
Ron de Bruin says:

January 11, 2008 at 9:14 am

Hi harald

Is that on more systems then one.
All Norwegian systems ?
bhabykhulethx says:

January 16, 2008 at 4:52 am

.. this website is very good ! every body have learn !
PeaBrain says:

October 7, 2008 at 6:41 pm

This has been driving me mad!!! I created a little Excel VBA project on my laptop for a friend who needed it password protected from other users. On mine, no problem. She has the exactly the same laptop model (an HP) and the same office enterprise version – yet trying passwords failed – even when I tried a simple user-input password in the worksheet open module – no vba code would execute. You are a god-send!!! Wish MS help was as helpful!