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
Dennis Wallentin:
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,
9 January 2008, 8:04 amDennis
Ron de Bruin:
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
9 January 2008, 9:20 amjkpieterse:
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.
9 January 2008, 12:34 pmRon de Bruin:
Hi JK
>file open password
But you are right that you have the same problem with workbook protection.
9 January 2008, 2:38 pmI will make this clear on this page
Ron de Bruin:
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.
10 January 2008, 1:37 pmHarald Staff:
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.
11 January 2008, 5:07 amRon de Bruin:
Hi harald
Is that on more systems then one.
11 January 2008, 9:14 amAll Norwegian systems ?
bhabykhulethx:
.. this website is very good ! every body have learn !
16 January 2008, 4:52 am