Had a good search but no luck. Can anyone help on this:
Got all my code in an add-in. It creates/deletes a custom menu item perfectly nicely on loading and closing. However I want that menu to be visible or enabled only when a specific named worksheet is loaded (and obviously the converse when it's closed).
I can figure this out by adding code to the worksheet, but I need it to be code free. So I guess what I'm asking for is an auto-sensing sort of thing that is run from the (loaded) add-in and checks a new worksheet open/close event.
Possible?
Got all my code in an add-in. It creates/deletes a custom menu item perfectly nicely on loading and closing. However I want that menu to be visible or enabled only when a specific named worksheet is loaded (and obviously the converse when it's closed).
I can figure this out by adding code to the worksheet, but I need it to be code free. So I guess what I'm asking for is an auto-sensing sort of thing that is run from the (loaded) add-in and checks a new worksheet open/close event.
Possible?