Click on Wrong Button

[ioncila]

Hi

I have this workbook with 10 sheets. Each sheet has macros that are called from a floating toolbar.

What I am trying to do:

I want to create a msgbox that warns me when I click in a toolbar's button to call a macro that not runs in the activesheet.

Something like: "This code (or macro) doesn't match (or run) with the active sheet. Do you want to go on?"

That maybe is simple, but I'm facing some dificulties to do that, so a little help will be welcome.

Thank you very much

[mudraker]

you would need to add code at the start of each macro
change sheet name to suit

Please Login or Register  to view this content.

[ioncila]

That's it. Thank you very much.

SOLVED

[Andy Pope]

You might consider adding some code the the SheetChange event in the Thisworkbook object which would enable/disable the buttons on the toolbar depending on the sheet.