Hiding the Standard Toolbar

[Guest]

Is there some code that will hide the Standard Tool bar when opening a
workbook and will restore it on close?

 

[Chip Pearson]

Andy,

Try

Sub Auto_Open()
Application.CommandBars("Standard").Visible = False
End Sub

Sub Auto_Close()
Application.CommandBars("Standard").Visible = True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Hi Chip,

Many thanks. This works a treat.

Kind Regards