Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Help Toolbar
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Help Toolbar
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 Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=27141 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Help Toolbar
P.S don't forget to turn them back on in your Auto_close module -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=27141 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel toolbar like word toolbar, please | Excel Discussion (Misc queries) | |||
Form Toolbar verses Control Toolbar | Excel Discussion (Misc queries) | |||
Adjusting toolbar size, restore toolbar | Excel Discussion (Misc queries) | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |