ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Placing a toolbar and it moves (https://www.excelbanter.com/excel-discussion-misc-queries/27249-placing-toolbar-moves.html)

Leon POLAK

Placing a toolbar and it moves
 
I apologise if we should know this (or if I should have been able to find
it), but...

When I start Excel I have a floating toolbar. If I move it up to the other
toolbar it stays there while I have Excel open. But as soon as I close and
re-start Excel it's back where it was originally.

I really didn't mind this too much (a bit annoying) but recently a user had
a similar problem with a different toolbar, it also starting out in the same
position each time.

I read some articles here and some mentioned *.xlb files - I could not find
any on my system (haven't had a chance to check the other user's system).

We're running Excel 2003, but he had previously had this problem with Excel
2002 as well before, I believe.

Any help would be much appreciated

Thanks

Leon POLAK
IT Services
Curtin Business School
Curtin University of Technology
Australia


Bob Phillips

How does the toolbar get created? You can always position it yourself.

Maybe in Personal.xls, add some code to the workbook open event to place it

Application.CommandBars("myToolbar").Position = msoBarTop


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Leon POLAK" <Leon wrote in message
...
I apologise if we should know this (or if I should have been able to find
it), but...

When I start Excel I have a floating toolbar. If I move it up to the other
toolbar it stays there while I have Excel open. But as soon as I close and
re-start Excel it's back where it was originally.

I really didn't mind this too much (a bit annoying) but recently a user

had
a similar problem with a different toolbar, it also starting out in the

same
position each time.

I read some articles here and some mentioned *.xlb files - I could not

find
any on my system (haven't had a chance to check the other user's system).

We're running Excel 2003, but he had previously had this problem with

Excel
2002 as well before, I believe.

Any help would be much appreciated

Thanks

Leon POLAK
IT Services
Curtin Business School
Curtin University of Technology
Australia





All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com