excel add-in

hello Experts,

We have a software that add add-in in excel. We were using office 2010.No we upgraded that to office 2016 and the add-in is gone. When we try to add the add-in manually we are getting error Error:1004: Programatic access to visual basic project is not trusted. I am adding the add-in manually. Is there any command or registry hack so that we can make a script to add the add-in. The addin is located in software folder located in c drive.

Regards
shyam pothiniAsked:
Who is Participating?
 
Serena HsiMarketing ConsultantCommented:
The MSDN support site has this recc for your error:

To enable or disable access to Visual Basic Projects
On the Tools menu in Word or Excel, point to Macro, and then click Security.
In the Security dialog box, click the Trusted Publishers tab.
Select to enable, or clear to disable, Trust Access to Visual Basic Project.
Click OK.

Also, if you are enabling this for all users:

HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Office\11.0\Excel\Security
Value : AccessVBOM
DWORD=1

1: To check the checkbox
0: To uncheck the checkbox

Or use group policy to configure this setting.

See also:

http://technet.microsoft.com/en-us/library/cc179057(office.12).aspx

If you are enabling it for just the user, replace HKEY_LOCAL_MACHINE with HKEY_CURRENT_USER
0
 
RaminTechnical AdvisorCommented:
Did you try to reinstall that software. add-in installs when you install the software.
0
 
shyam pothiniAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.