Show / Hide CustomToolbar

[Graham]

Hi,

I have created a custom toolbar which I only want to be
visible when a certain sheet within my workbook is active.
Is there some coding that I can use to show or hide the
toolbar depending on which sheet within the workbook has
been selected?

Help gratefully received

Thanks
Graham

 

[Dave Peterson]

There's a worksheet_activate and worksheet_deactivate that you could use.

(along with the versions for workbook (swapping between workbooks means
hiding/unhiding the toolbar????))

And if you want to learn more about what events are:

Chip Pearson has some notes about events at:
http://www.cpearson.com/excel/events.htm

David McRitchie also has notes at:
http://www.mvps.org/dmcritchie/excel/event.htm

Chip has a note near the bottom of his page where you can download EventSeq.xls
to see what runs when.