Macros are disabled when you open password protected workbooks
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
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
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
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.
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
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.
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.
Hi harald
Is that on more systems then one.
All Norwegian systems ?
.. this website is very good ! every body have learn !
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!