ExcelBanter - Hiding the Standard Toolbar

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding the Standard Toolbar (https://www.excelbanter.com/excel-discussion-misc-queries/1940-hiding-standard-toolbar.html)

Andy T

Hiding the Standard Toolbar

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

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

"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

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

All times are GMT +1. The time now is 12:38 PM.