Hi Anthony

You can use this events in the thisworkbook module to run your code

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub

For more information see
http://www.rondebruin.com/menuid.htm



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



"Anthony" wrote in message ...
Hi
Can anybody advise how I can close or hide the 'Formatting', 'Standard',
'Formula', 'Status' and the 'Worksheet Menubar' toolbars when my excel
worksheet is opened, but NOT affect their apperance in any other excel
worksheet.
I would imagine it takes some VBA script, but any ideas for a novice ??
thanks