hiding menubar & toolbar

  • Thread starter Thread starter =?iso-8859-1?Q?SIMON=C9?=
  • Start date Start date
?

=?iso-8859-1?Q?SIMON=C9?=

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
 
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
 
Back
Top