|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 10th, 2002, 09:54 AM
|
#1 |
|
Board Regular
Join Date: Mar 2002
Location: Manchester, UK
Posts: 95
|
How do I set the position of my custom toolbar to Top Left. If I use Position.msoBarTop the bar always goes top right and doesn't look nice!!
|
|
|
|
Apr 10th, 2002, 10:00 AM
|
#2 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
Hi
Can't you just set the Top and Left properties to 0? Tom |
|
|
|
|
Apr 10th, 2002, 10:39 AM
|
#3 |
|
Board Regular
Join Date: Mar 2002
Location: Manchester, UK
Posts: 95
|
Don't wanna sound too dumb, but how do I do that?
|
|
|
|
|
Apr 10th, 2002, 11:15 AM
|
#4 |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
Not dumb!
I might be wrong. Most objects have a Top, Left, Width, and Height Properties. If you are needing to corner you toolbar in the upper-left hand corner, then the Top and left would = 0 Try this: Application.CommandBars("YourCommandBarName").Top = 0 Application.CommandBars("YourCommandBarName").Left = 0 Tom |
|
|
|
|
Apr 10th, 2002, 11:31 AM
|
#5 |
|
Board Regular
Join Date: Mar 2002
Location: Manchester, UK
Posts: 95
|
Cheers Tom
Much Appreciated. |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
