Hiding the Standard Toolbar

[Andy T]

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 Autpen()
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

 

[Andy T]

Hi Chip,

Many thanks. This works a treat.

Kind Regards