Trust VB projects setting Grayed out

[David Liebtag]

I am copying text from some posts that are so old I can't seem to reply to
them any more. Sorry for the duplication.

I wrote in microsoft.public.excel:

I am working on some code that uses COM to manipulate VB code in Excel. I
know that my users need to check the "Trust access to Visual Basic
project"
checkbox in Excel's security settings in order to access VBProjects.
However, one of my beta testers reports that the checkbox is disabled on
his
machine and we can't figure out why.

Does anyone know what conditions would cause this checkbox to be disabled?

Dave Peterson responded:

Take a look at Jim Rech's response in this thread:
http://google.co.uk/groups?threadm=#[email protected]

OK, I found the answer. If anyone is interested. I had changed the key

HKLM\Software\Microsoft\Office\11\Excel\Security\AccessVBOM to 1.

I expected this to make the UI check box a non-greyed-out option, but it
left it greyed out. But the box was not checked instead of unchecked.

So here is how it works. If you leave the key there and it is a zero the
option will be greyed out and unchecked. If you leave the key there and
make it a 1, the option will be greyed out but checked. If you remove
the
key entirely the option will no longer be greyed out and the user can
chose
to check it or not.

Unfortunately, I'm still having trouble.

The key HKLM\Software\Microsoft\Office\11\Excel\Security\AccessVBOM does not
exist in the registry on my machine. In fact, there is no Office\11 key; I
have Excel 2002 and only have an Office\10.0 key. There is no
Security/AccessVBOM key or value.

I tried adding the value to my 10.0 registry key and it had effect. They
checkbox is still enabled.

I am trying to formulate instructions I can give my customers for how to
enable the Trust access to Visual Basic Project check box. Can anyone
direct me to official documentation about these keys which describes how
they are used for different versions of Excel?

Thank you very much.

David Liebtag
IBM APL Products and Services

 

[Tom Ogilvy]

Possibly the supplemental documentation from the resource kit

Down load
orkdocs.exe from

http://office.microsoft.com/en-us/assistance/HA011362911033.aspx

it should contain the file regkey.xls

Regkey.xls Lists default registry key values.


I doubt you will find a discussion, however.

there was no requirement for such a key in xl2000 and earlier as I recall.

 

[David Liebtag]

Thanks Tom.

The Regkey.xls lists three AccessVBOM registry entries for Excel. Two of
them weren't on my machine and one that was on my machine was not listed in
regkey.xls. I've tried tweaking all four entries and nothing has disabled
the checkbox. Maybe it can't be disabled with my version of Excel.

David Liebtag

 

[Tom Ogilvy]

Did you understand the text you quoted.

As I understood it:
If the key exists, then the checkbox is disabled (You situation)
Then if the key value is 1, the box is checked and if zero it is not
checked

If the key does not exist, then the checkbox is enabled. So if you want
the checkbox enabled, then remove the key.

Just going on what I read/understood - no knowledge on whether that is true
or not.

 

[David Liebtag]

Tom,

Yes, I understood the text I quoted. By default, my machine has the key and
the checkbox is enabled. So at least with my version of Excel, the
existence of the key does not disable the checkbox.

I've found some more keys in the regkey file which look like they may effect
the checkbox. If I find anything useful, I will post the info.

Thanks.

David Liebtag