I have a macro in a spreadsheet which is linked to a toolbar button in the
usual way.

Is there any way please that the button can be deactivated (and if possible
greyed out) when the spreadsheet in question is not the active sheet?

TIA

V