Placing a toolbar and it moves

G

Guest

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top