Try this examples

If you only want to hide the menu bar use

Application.CommandBars(1).Enabled = False


Sub hide()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = False
Next
End Sub

Sub show()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = True
Next
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"SIMONÉ" wrote in message ...
how do I hide the menu bar - File Edit Tools etc , when
the workbook is opened?

I would also like to hide all the toolbars?

Please help