Thread: Toolbars
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nikos Yannacopoulos[_5_] Nikos Yannacopoulos[_5_] is offline
external usenet poster
 
Posts: 80
Default 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