Results 1 to 12 of 12
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trust Access to VBA (Excel 2003)

    I want to run VBA Cleaner but I can't enable the 'trust access to vba project' in the Security menu. It's grayed out and I don't know why. I've been able to turn it on in the past but don't know what has changed such that it's disabled. <img src=/S/confused.gif border=0 alt=confused width=15 height=20> I even see it grayed out on a new/empty workbook. I do have a digital cert installed if that matters (although it wasn't attached to the new/empty workbook I just now opened).

    (I'm doing this because I now get that infamous message "Bad DLL Calling Convention" which I know is bogus. I've edited this .xls file so many times it's now full of sludge.)

    Thnx, Deb

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    I have the same problem. I'll ask around.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    Hi Deb,

    I got this from the MVP group:

    (seems to be an old newsgroup post by a guy that names himself KeepItCool)

    the registry setting was moved from user to machine
    and you can no longer change it from the UI.

    Run the program regedit.exe
    goto:
    HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice11.0Excel Security
    Add or Change a DWORD named AccessVBOM to Value 1
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    Thanks for the deep dive research. I did the registry change and now see that it is checked however it's still grayed out which I guess makes sense (sort of, in a MS way) since it's a registry setting now. It didn't use to be like that right? I know in previous revs (2002/XP) that I could change it directly in the Security menu.

    I did a search in the help from w/in Excel for the term 'trust access' and it tells me to change the checkbox in the Security menu <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15> , so again the Help hasn't been updated with changes in the program.

    Ok, mystery solved but now they've made it especially difficult for many users since a lot of them don't want to (or don't know how) to edit the registry. I'd think this would make using some add-ins much harder as well (which is what started this whole thread).

    Thnx,
    Deb <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Trust Access to VBA (Excel 2003)

    The old fashioned behaviour still works fine for me, using Excel 2003 (11.6355.6408) SP1

    I do not have a Security key in the registry under HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice11.0Excel
    I only have InstallRoot
    I wonder what would happen if you completely deleted the Security registry key (best export it before playing though).

    StuartR

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    Good guess. Yes I deleted the keyword "AccessVBOM" and now the checkbox is available (not grayed out) in the Security menu. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> I'll keep the registry as it is now - w/o that keyword since I'd rather have access to that field w/in Excel and not through a registry edit.

    Under 11.0Excel I have both InstallRoot and Security as keys. I left both keys but removed the entry SecurityAccessVBOM. This didn't affect how my digital cert works though - I can still attach one.

    (I too have Office 2003/SP1 - this is my work laptop which is my main PC imaged from my employer.)

    Thnx,
    Deb

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    I deleted the entry too, with the same (desired) effect.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    me 2

  9. #9
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    the securiy key is supposed to be present.
    i have it, and i have access to the trusted vb check box on the gui.

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    You only need to get rid of the AccessVBOM entry below the security key.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    no reason to get rid of that key, it's supposed to be there.

    on my system it's value is 1 (REG_DWORD)

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trust Access to VBA (Excel 2003)

    Yes there is.

    For "normal" operation, Excel uses:

    HKEY_CURRENT_USERSOFTWAREMicrosoftOffice11.0ExcelS ecurityAccessVBOM

    As soon as THIS key exists:

    HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice11.0ExcelSecurityAccessVBOM

    it overrides the previously mentioned key AND greys out the option on Excel's menu.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •