hiding toolbars for my workbook only

I know how to hide toolbars and restore them. If there a way to restore the
toobars when the user opens another workbook and hide them again when
returning to mine?

Hi JNW

http://www.rondebruin.com/menuid.htm

Use this two events in the Thisworkbook module.

Read more about events on Chip Pearson's site.
http://www.cpearson.com/excel/events.htm

Private Sub Workbook_Activate()
'your code to change Enabled to False
'Or the name of your macro
End Sub

Private Sub Workbook_Deactivate()
'your code to change Enabled to True
'Or the name of your macro
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"JNW" <JNW@discussions.microsoft.com> wrote in message news:1F3E5BD8-D046-4D6B-9576-8ED716D7D9D4@microsoft.com...
>I know how to hide toolbars and restore them. If there a way to restore the
> toobars when the user opens another workbook and hide them again when
> returning to mine?