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