Patrick Starkey
asked on
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?
"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?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Your suggestion solved the issue. Thanks for your help!
Pleased to help.
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.