Single machine cannot run addin macros from Ribbon.

I have an excel addin loaded on multiple machines (all pointing to the same xlam file on a server), all but one can run macros from the ribbon buttons.  The one machine that cannot, the macros can run if I call them from inside the VBA editor (which upon opening shows the addin in the tree view).  So I know it is not a security settings issue an addin unloaded issue, not a syntax issue because everyone else runs the macros from the same ribbon buttons without issues.  The ribbon buttons were created using the customize ribbon within Excel, not coded manually.  I have unloaded and reloaded the addin to no avail.  The machine in question ran these macros from the ribbon without issue for over a year and now mysteriously spits out the message:
"cannot run the macro the macro may not be available in this workbook or all macros may be disabled"
Any clues to what could make the ribbon unable to call a macro on a single machine, when it is able to run if called from the vba editor?
Patrick StarkeyAsked:
Who is Participating?
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
I would also try using the CustomUI Editor on the Ribbon. It's more work but I find it more reliable.
0
 
Roy CoxGroup Finance ManagerCommented:
I find the best way to modify the Ribbon is to use the CustomUI Editor as outlined by Ron de Bruin with templates

Ribbon and Quick Access Toolbar(QAT)

I take it you have checked Macro Security Settings. It might be worth running a repair on Excel in case any update has affected the settings.
0
 
Patrick StarkeyAuthor Commented:
The Macro security is set appropriately, and the access to the VBA project is checked, the addin's location is within the trusted locations.  Macros work from VBA, but cannot be called by the ribbon on this one machine where they had in the past.  I will look into running a repair on Excel.  Thanks.
0
 
Patrick StarkeyAuthor Commented:
Your suggestion solved the issue.  Thanks for your help!
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help.
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.