Excel Help Toolbar

[JK]

My application deletes the Excel toolbar and inserts my toolbar. It works
fine. But my toolbar still has Excel's Help to the far right. Is there a way
to get it off my toolbar?

Thank you for allowing me a second question, and thank you in advance for
your suggestions.

Jim Kobzeff

 

[Simon Lloyd]

Try this, the first 3 lines turn standard menubars off, the 4th you nee
to insert your menu bar name and the next 2 lines (which you can repeat
are to assign subs to buttons when the workbook is opened (modify wit
your names).

Hope this helps

Simon

Sub Auto_open()

With Application
.CommandBars.ActiveMenuBar.Enabled = False
.CommandBars("Formatting").Visible = False
.CommandBars("Standard").Visible = False
.CommandBars("your menubar name").Visible = True
.CommandBars("your menubar name").Controls("your butto
name").OnAction = "your sub name"
.CommandBars("your menubar name").Controls("your butto
name").OnAction = "your sub name"
.DisplayFullScreen = False
.DisplayFormulaBar = False
.DisplayStatusBar = False
End With
End Su

 

[Simon Lloyd]

P.S don't forget to turn them back on in your Auto_close module