• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1012
  • Last Modified:

Lock Excel 2003 Toolbars

How do you get the positions of the Excel 2003 toolbars to stay in same position from one use of app until next?

thx
0
TURKTHEMAN
Asked:
TURKTHEMAN
  • 5
  • 4
2 Solutions
 
Rory ArchibaldCommented:
Do you mean the built-in toolbars, or custom ones?
0
 
TURKTHEMANAuthor Commented:
Built-in toolbar = Acrobat and Avery Icons on bar...

thx
0
 
TURKTHEMANAuthor Commented:
Change that to:

Built-in toolbar + Acrobat and Avery Icons on bar...
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rory ArchibaldCommented:
That doesn't sound like a built-in toolbar to me, or have you added those icons to one of the built-in toolbars?
Rory
0
 
TURKTHEMANAuthor Commented:
Rory,

When I say "Built-in toolbar + Acrobat and Avery Icons on bar...", what I am meaning is in addition to the built-in toolbars, after installing Acrobat there's a small Acrobat toolbar consisting of 2 icons, plus after having installed the Avery Wizard program there is another small toolbar consisting of 1 icon.   It is mainly the Avery toolbar that moves from where I place it upon reopening Excel.

Thanks.


0
 
Rory ArchibaldCommented:
Since I believe those toolbars are created in code each time you start Excel by the add-ins, there isn't anything much you can do about them, I'm afraid.
0
 
TURKTHEMANAuthor Commented:
Thanks- I was afraid of that... I was hoping that someone might have a hack for the code modification or override to cope with that.   The only option I see now is to remove the Avery toolbar... not a big deal, just an annoyance.
0
 
Rory ArchibaldCommented:
If the Avery add-in is not protected, you could alter the code in it. Alternatively you could use startup code in your personal macro workbook to reposition the other toolbars - a bit clunky, but should work.
0
 
TURKTHEMANAuthor Commented:
After thinking about what you said, and then looking at http://www.pcreview.co.uk/forums/thread-3722796.php, I just decided to get rid of it by unchecking the "Avery Assistant Toolbar" in Tools --> Customize --> Toolbars.

I then moved all the toolbar icons together in the first row and closed Excel.  Now, when I reopen it, the Avery Toolbar reinserts itself at the right end of the first row, which is fine for me.    I've closed and reopened Excel several times, and it seems to stay there.

So we haven't modified the code or anything, but just learned one way to place the icon within the context of its own behavior of auto-loading.  

Thanks for the input, Rory... It helped me to find this solution.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now