Thread: Deactivating a macro button
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
  
Posts: 199
Default Deactivating a macro button
Thanks,

V

"Don Guillett" wrote in message
.. .
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

"Victor Delta" wrote in message
...
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


Reply With QuoteReply With Quote