I have a list of macros in a hidden Excel sheet, which supplies the macro to be called when a specified customised ribbon BUTTON is clicked
Using Excel.Application.Run (macroName) , how do I deal with the event that macroName is listed in my lookup sheet, but does not exist as a sub?
The call for a macro includes this:
If macroName <> "" Then
Application.ScreenUpdating = False
rib_context.Visible = xlSheetVisible
rib_context.Visible = xlSheetHidden
Application.ScreenUpdating = True
BUT if I call a macroName for a non-existent Macro, no error is reported by vba. Is there a vba check that I can apply to guard against calling a non-existent macro?
This is the first time I've used for my Customised Ribbon and I depend on it working.
If you have criticisms of my approach - I'd surely welcome them now!