Stacie,

You need to put some code in the ThisWorkbook object of you
spreadsheet that amends the toolbar.

The two events you need to look a

Workbook_Activate

and

Workbook_Deactivate

In _Activate you place some code (or a call to a sub) to amend th
toolbar as required. In _Deactivate you place code (or a call to
different sub) to return the toolbar to its default state.

Where have you placed the code that amends the toolbar currently?

TheDuc

--
Message posted from http://www.ExcelForum.com