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.



JRD wrote:

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

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

Jim

--
JRD
------------------------------------------------------------------------
JRD's Profile: http://www.excelforum.com/member.php...fo&userid=5203
View this thread: http://www.excelforum.com/showthread...hreadid=489803

--

Dave Peterson