Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars
I am trying to add some Toolbars via my personal.xls as for some reason my
toolbars reset each time I exit Excel. I have tried using the code below to add the toolbars they are floating toolbars. Application.CommandBars("WordArt").Visible = True Does anyone know of a way that I can stick these to the toolbar? I use Windows NT with Excel 97 Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars
Edgar,
Try this Application.CommandBars("WordArt").Visible = True Application.CommandBars("WordArt").Position=msoBar Top Application.CommandBars("WordArt").RowIndex = 128 The second line will put the toolbar at the top, right under the menubar and above the already existing toolbars. The third line will put it below the already existing toolbars. RowIndex can take values 0 - 128, and giving it an equal value as an existing toolbar will put it next to the latter on the same row. Experiment with it to see how it works. HTH, Nikos "Edgar Thoemmes" wrote in message ... I am trying to add some Toolbars via my personal.xls as for some reason my toolbars reset each time I exit Excel. I have tried using the code below to add the toolbars they are floating toolbars. Application.CommandBars("WordArt").Visible = True Does anyone know of a way that I can stick these to the toolbar? I use Windows NT with Excel 97 Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars
Edgar,
Try this Application.CommandBars("WordArt").Visible = True Application.CommandBars("WordArt").Position=msoBar Top Application.CommandBars("WordArt").RowIndex = 128 The second line will put the toolbar at the top, right under the menubar and above the already existing toolbars. The third line will put it below the already existing toolbars. RowIndex can take values 0 - 128, and giving it an equal value as an existing toolbar will put it next to the latter on the same row. Experiment with it to see how it works. HTH, Nikos "Edgar Thoemmes" wrote in message ... I am trying to add some Toolbars via my personal.xls as for some reason my toolbars reset each time I exit Excel. I have tried using the code below to add the toolbars they are floating toolbars. Application.CommandBars("WordArt").Visible = True Does anyone know of a way that I can stick these to the toolbar? I use Windows NT with Excel 97 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toolbars | New Users to Excel | |||
toolbars | Excel Discussion (Misc queries) | |||
toolbars | Excel Discussion (Misc queries) | |||
toolbars | Excel Programming | |||
Toolbars | Excel Programming |