How do I Enable and Disable a custom Ribbon button based on the Excel file that is open?
I created a custom Button, with Groups.
The goal is I have 7 groups.
The main Ribbon button should be disabled if none of a list of Excel file names is not open.
If a specific file name is open, I want to enable only that group that the macro is intended for.
See attached image.
Bookmarks