ExcelBanter - Toolbars

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

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

- - Toolbars (https://www.excelbanter.com/excel-discussion-misc-queries/38565-toolbars.html)

dstiefe

Toolbars

I've created my own toolbar. what VBA code would I write to select/delete
that specific toolbar?

FSt1

hi,
Add a custom tool bar:
Application.CommandBars.Add(Name:="CTB").Visible = True
Delete a custom tool bat:
Application.CommandBars("CTB").Delete
Hide a custom tool bar:
Application.CommandBars("CTB").Visible = False
Show a custom tool bar:
Application.CommandBars("CTB").Visible = True

regards
FSt1

"dstiefe" wrote:

I've created my own toolbar. what VBA code would I write to select/delete
that specific toolbar?

dstiefe

thank you

"FSt1" wrote:

hi,
Add a custom tool bar:
Application.CommandBars.Add(Name:="CTB").Visible = True
Delete a custom tool bat:
Application.CommandBars("CTB").Delete
Hide a custom tool bar:
Application.CommandBars("CTB").Visible = False
Show a custom tool bar:
Application.CommandBars("CTB").Visible = True

regards
FSt1

"dstiefe" wrote:

I've created my own toolbar. what VBA code would I write to select/delete
that specific toolbar?

All times are GMT +1. The time now is 07:06 PM.