Deactivating a macro button

  • Thread starter Thread starter Victor Delta
  • Start date Start date
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
 
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.
 
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
(e-mail address removed)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

enabling/disabling a set of code from within a spreadsheet sheet 2
Macro for active sheet only 4
Conditional formatting causing auto complete to deactivate? 3
Deactivate worksheet 3
Changing sheets after the DeActivate Event. 2
Excel Macro to un-mute Audio/speakers. 15
Save a macro button onto a toolbar 7
Deactivate button on criteria 3

Back
Top