« Excel User Group Site
Can’t Access Table in MS Query »

Macros are disabled when you open password protected workbooks

9th January 2008, 07:35 am 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

Category: General, Excel12  |  Comment (RSS)  |  Trackback

8 Comments

  1. 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,
    Dennis

    9 January 2008, 8:04 am

  2. 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 am

  3. jkpieterse:

    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 pm

  4. Ron de Bruin:

    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

    9 January 2008, 2:38 pm

  5. 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 pm

  6. Harald 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 am

  7. Ron de Bruin:

    Hi harald

    Is that on more systems then one.
    All Norwegian systems ?

    11 January 2008, 9:14 am

  8. bhabykhulethx:

    .. this website is very good ! every body have learn !

    16 January 2008, 4:52 am

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment