Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trust VB projects setting Grayed out
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=%...GP11.p hx.gbl In that thread, Dennis wrote: OK, I found the answer. If anyone is interested. I had changed the key HKLM\Software\Microsoft\Office\11\Excel\Security\A ccessVBOM 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\A ccessVBOM 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trust VB projects setting Grayed out
Possibly the supplemental documentation from the resource kit
Down load orkdocs.exe from http://office.microsoft.com/en-us/as...362911033.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. -- Regards, Tom Ogilvy "David Liebtag" wrote in message ... 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=%...GP11.p hx.gbl In that thread, Dennis wrote: OK, I found the answer. If anyone is interested. I had changed the key HKLM\Software\Microsoft\Office\11\Excel\Security\A ccessVBOM 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\A ccessVBOM 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trust VB projects setting Grayed out
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trust VB projects setting Grayed out
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. -- Regards, Tom Ogilvy "David Liebtag" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trust VB projects setting Grayed out
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trust Center settings via GPO | Setting up and Configuration of Excel | |||
Trust center log | Setting up and Configuration of Excel | |||
Trust VB projects setting Grayed out | Excel Programming | |||
Trust and Signatures in VBA | Excel Programming | |||
How to become a better programmer, post college. More projects or less projects. | Excel Programming |