Deactivating a macro button

V

Victor Delta

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
 
D

Don Guillett

You could use sheet activate and sheet deactivate macros to
install/uninstall the button. OR, just put a non-printable shape on the
desired sheet.
 
V

Victor Delta

Thanks,

V

Don Guillett said:
You could use sheet activate and sheet deactivate macros to
install/uninstall the button. OR, just put a non-printable shape on the
desired sheet.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]
Click to expand...
 
Top