Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
M. M. is offline
external usenet poster
 
Posts: 18
Default toolbar position

Excel97!
Whene i'm opening my workbook, vba code created on the fly my toolbar. Excel
positioned my toolbar below other excel toolbar. Could i write some code to
position my toolbar to the right of other defolt excel toolbar. My toolbar
contained only two toolbar buttons, there for is enought smoll to bi
positioned to the right of other excel toolbar.

Regards,
Milos


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default toolbar position

Try this, not sure if it work

Sub BarPosition()
Dim BarLeft As Long

BarLeft = Application.CommandBars("Standard").Width + 1

With Application.CommandBars("Your toolbar name")
.Position = msoBarTop
.Left = BarLeft
.Visible = True
End With
End Sub


"M." wrote in message
...
Excel97!
Whene i'm opening my workbook, vba code created on the fly my toolbar.

Excel
positioned my toolbar below other excel toolbar. Could i write some code

to
position my toolbar to the right of other defolt excel toolbar. My

toolbar
contained only two toolbar buttons, there for is enought smoll to bi
positioned to the right of other excel toolbar.

Regards,
Milos




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel toolbar like word toolbar, please Meng[_2_] Excel Discussion (Misc queries) 1 May 23rd 09 04:28 PM
Form Toolbar verses Control Toolbar ub Excel Discussion (Misc queries) 3 July 11th 08 10:57 PM
Save Toolbar into new toolbar [email protected] Excel Discussion (Misc queries) 2 March 4th 08 11:16 AM
Adjusting toolbar size, restore toolbar Josh M Excel Discussion (Misc queries) 1 January 18th 06 06:17 PM
saving toolbar buttons on custom toolbar Paul James Excel Programming 12 August 6th 03 08:28 AM


All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"