Show / Hide CustomToolbar
 

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

Show / Hide CustomToolbar
 

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 a

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.



Graham wrote:

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