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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Roy CoxGroup Finance ManagerCommented:
I would also try using the CustomUI Editor on the Ribbon. It's more work but I find it more reliable.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Patrick StarkeyAuthor Commented:
Your suggestion solved the issue.  Thanks for your help!
0
Roy CoxGroup Finance ManagerCommented:
Pleased to help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Customized Ribbon Buttons

From novice to tech pro — start learning today.