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

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





"Andy T" wrote in message
...
Is there some code that will hide the Standard Tool bar when
opening a
workbook and will restore it on close?
--
Andy T

Hi Chip,

Many thanks. This works a treat.

Kind Regards

"Chip Pearson" wrote:

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





"Andy T" wrote in message
...
Is there some code that will hide the Standard Tool bar when
opening a
workbook and will restore it on close?
--
Andy T