Showing custom toolbars on one W/S only

[JRD]

I have created several custom toolbars in a workbook that I call in the
Workbook_Open event and close in Workbook_BeforeClose.

The toolbars really only apply to one worksheet and I would like for
them to only be visible one that sheet. Does anyone have a suggestion
on how I can make them invisible on the other worksheets?

Please keep it simple. Even though I've cobbled together this workbook
over the past couple of years, I am far from an expert. Many Thanks...


Jim

 

[Dave Peterson]

Hide (or delete) them with the worksheet_deactivate and restore them with the
worksheet_activate events.

(And same with workbook_activate/_deactivate so they're hidden when you swap
workbooks.)

I went to google groups and searched for workbook_deactivate. I sorted the
results by date and found this thread:

http://groups.google.co.uk/group/mi...e+group:*excel*&rnum=3&hl=en#14f7dde5a0477be9

or

http://snipurl.com/iiye

I'm sure you can find samples of worksheet_activate/_deactivate.

 

[JRD]

This has almost got it. I added the code that activates/deactivate
the toolbars and put the worksheet_activate on the one I want (Estimat
Sheet) and put the worksheet_deactivate on all the other sheets. Thi
seems to work fine, except for one little thing.

After activating the toolbars by clicking on the Estimate Worksheet,
then have to select TWO sheets for the toolbars to disappear. Fo
instance, if I click on Worksheet1, then the toolbars are stil
visible. If I click on Worksheet2, then they disappear and don'
reappear until I select the Estimate Worksheet again. Does this mak
sense?


Ji

 

[Dave Peterson]

Ooh. I think I would have used the worksheet_deactive event in that one
worksheet and used it to hide the toolbar.

I don't think you needed to touch those other sheet events at all.