Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
Hello developers,
How to enable Excel 2007 "Trust access to the VBA project object model" option during VSTO add-in setup? My add-in requires that this security option is enabled. I tell users to manually turn this on before they run setup but some of them forget. I hope this can be automated somehow. I searched Google but found nothing about corresponding registry entry. Thanks for any pointers Thomas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" durin
This is a security issue ... if you could do it with code, there would be no
security would there? "Thomas" wrote: Hello developers, How to enable Excel 2007 "Trust access to the VBA project object model" option during VSTO add-in setup? My add-in requires that this security option is enabled. I tell users to manually turn this on before they run setup but some of them forget. I hope this can be automated somehow. I searched Google but found nothing about corresponding registry entry. Thanks for any pointers Thomas . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
I am not familiar enough with VSTO, but I know it can't be done via code
with VBA, and I would think (hope!) it is the same in VSTO. The user should determine whether they want to set it. -- __________________________________ HTH Bob "Thomas" wrote in message ... Hello developers, How to enable Excel 2007 "Trust access to the VBA project object model" option during VSTO add-in setup? My add-in requires that this security option is enabled. I tell users to manually turn this on before they run setup but some of them forget. I hope this can be automated somehow. I searched Google but found nothing about corresponding registry entry. Thanks for any pointers Thomas |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" duringVSTO add-in setup?
I don't speak VSTO, but I hope what you're asking for is not possible.
This is a security setting (my security setting!). Your program shouldn't be able to change this. If your program can do it, then anyone (including malware) could do it. If you find a way to do this, I hope that you change the setting back to what it was when you're done. Thomas wrote: Hello developers, How to enable Excel 2007 "Trust access to the VBA project object model" option during VSTO add-in setup? My add-in requires that this security option is enabled. I tell users to manually turn this on before they run setup but some of them forget. I hope this can be automated somehow. I searched Google but found nothing about corresponding registry entry. Thanks for any pointers Thomas -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
I did not say I wanted to alter this settings from within Excel, perhaps
using VBA. I believe it is stored somewhere in registry and can be changed as a part of setup. Thomas |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
I am afraid I do not express myself clearly.
I wrote: "enable [...] option during VSTO add-in setup" while most people trying to help (thank you) read it: change using VBA, perhaps from within the Excel application. Thomas "Bob Phillips" wrote in message ... I am not familiar enough with VSTO, but I know it can't be done via code with VBA, and I would think (hope!) it is the same in VSTO. The user should determine whether they want to set it. -- __________________________________ HTH Bob "Thomas" wrote in message ... Hello developers, How to enable Excel 2007 "Trust access to the VBA project object model" option during VSTO add-in setup? My add-in requires that this security option is enabled. I tell users to manually turn this on before they run setup but some of them forget. I hope this can be automated somehow. I searched Google but found nothing about corresponding registry entry. Thanks for any pointers Thomas |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
Altering it from anywhere amounts to the same thing.
-- __________________________________ HTH Bob "Thomas" wrote in message ... I did not say I wanted to alter this settings from within Excel, perhaps using VBA. I believe it is stored somewhere in registry and can be changed as a part of setup. Thomas |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" duringVSTO add-in setup?
And I didn't suggest that you were trying to alter the setting from within
excel. I think it's a bad idea no matter what approach is used. Thomas wrote: I did not say I wanted to alter this settings from within Excel, perhaps using VBA. I believe it is stored somewhere in registry and can be changed as a part of setup. Thomas -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
This Excel setting can be changed with three lines of C# code.
Thomas RegistryKey key = Registry.CurrentUser.OpenSubKey(@"Software\Microso ft\Office\12.0\Excel\Security", true); key.SetValue("AccessVBOM", 1); key.Close(); |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
Hi Thomas,
You found the right key. However, I suggest you not to do that in your setup, instead, you can set the value in your add-in. That's because you're operating the HKCU, which means this option is per user instead of machine wide. You may also consider put a warning dialog letting the users know about the setting change, just like what VSTO does in design time. I have a sample in the CodeFx project (http://cfx.codeplex.com/) called CSVstoVBAInterop, which demonstrates the use of this setting and some VBA interop features. Regards, Jie Wang Microsoft Online Community Support Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: . ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/en-us/subs...#notifications. Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 2 business days is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to enable "Trust access to the VBA project object model" during VSTO add-in setup?
Many thanks, Jie. I will try that.
Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Trust Access to Visual Basic Project" checked but getting error 6 | Excel Programming | |||
"Trust Access to Visual Basic Project" checked but getting error 6 | Excel Programming | |||
How can I verify if "Trust access to visual basic project" is chec | Excel Programming | |||
Registry key for "Trust access to Visual Basic project" | Excel Programming |