D
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:
Dave Peterson responded:
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
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