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?

hiding toolbars for my workbook only
 

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" wrote in message ...
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?