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/mic...f7dde5a0477be9

or

http://snipurl.com/iiye

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

JRD wrote:

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

--
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