Placing a toolbar and it moves

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Back
Top