Trust Access to VBA (Excel 2003)

Topic

New Reply

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

Reply | Quote

Replies

I have the same problem. I’ll ask around.

Reply | Quote

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.0ExcelSecurity
Add or Change a DWORD named AccessVBOM to Value 1

Reply | Quote

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 , 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

Reply | Quote

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

Reply | Quote

Good guess. Yes I deleted the keyword “AccessVBOM” and now the checkbox is available (not grayed out) in the Security menu. 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

Reply | Quote

I deleted the entry too, with the same (desired) effect.

Reply | Quote

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

Reply | Quote

You only need to get rid of the AccessVBOM entry below the security key.

Reply | Quote

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

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

Reply | Quote

Yes there is.

For “normal” operation, Excel uses:

HKEY_CURRENT_USERSOFTWAREMicrosoftOffice11.0ExcelSecurityAccessVBOM

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.

Reply | Quote

me 2

Reply | Quote