sorry Ron but I'm a bit of a novice when it comes to VB.
I have opened the VB code and pasted urs (from ur orig reply) into the
thisworkbook module, but it doesn't seem to do much !
if I open my excel workshhet again , all the toolbars I want to hide are
still there !
HELP PLEASE !!

"Ron de Bruin" wrote:

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