Permanently Changing a Toolbar

[Mark P]

I'm running Excel 2003. I installed an Excel toolbar from Avery (for
label-making). I want to change the position of the toolbar. I can move it,
but every time I re-open Excel the toolbar is in the original location. I
also installed the toolbar on Word, but it isn't giving me this problem. How
do I get the toolbar to stay put?

 

[Riccol]

I have the exact same problem (Excel 2002). And besides it not staying
where you put it, it always re-appears every time I re-open Excel even
though I repeatedly UNcheck it from the View-Toolbars list.

Wouldn't be so bad except it insists on making a whole third toolbar row
all for itself. I think I'm just going to uninstall the dang thing.

 

[Gord Dibben]

First you have to determine how Avery is adding the Toolbar.

Is it through an add-in? Uncheck the add-in.

Did Avery stick a file in your XLSTART folder?

What type of file is it?

If an *.xla file, move it out of there and put it in your Office\Library
folder where you can load or unload as you wish.


Gord Dibben MS Excel MVP

 

[Riccol]

In my case, it's not included in the list of add-ins you can view thru
the program nor is there anything in the add-ins folder itself.
And there's nothing in my XLSTART folder except for the personal.xls I
added today. Anywhere else to look?

 

[Gord Dibben]

You will have two XLSTART folders.

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

C:\Program Files\Microsoft Office\OFFICE10\XLSTART

Or maybe check in Tools>Options>General "At startup open all files in"

Only if you have a path entered there.

Elsewise, how did you install the Avery Labelmaker?

You might get an idea from the install routine.


Gord

 

[Riccol]

C:\Program Files\Microsoft Office\Office10\XLStart
is empty and if it's in
C:\Program Files\Microsoft Office\Office10\AddIns
it's not going by a name that makes it apparent it's Avery.

"At startup open all files in" is blank.

I installed it so long ago, I have no idea what the process was.

 

[Gord Dibben]

I'm out of ideas.

Could even be a *.dll that Avery installs.


Gord

 

[Dave Peterson]

Can you see the project associated with the Avery file in the VBE project
explorer?

If yes, then maybe you can use that to help.

Open excel
Verify that the Avery toolbar is there
Open the VBE (alt-f11 is one way)
hit ctrl-r to see the project explorer.

Look for that avery addin/workbook's project
It'll have the format of:
ProjectName (FileName.xl?)

If you see it, then hit ctrl-g (to view the immediate window).
type this in that window and hit enter:
?workbooks("filename.xls").fullname

Make a note of the path/file
close the VBE
close excel
Use windows explorer to traverse to that folder and move (or delete???) that
file.

=============
But there are other places that excel can use to load a file.

One is the registry
And another is as a COM Addin.

I'm gonna skip the registry suggestion until you check the first suggestion and
then check the COM addin locations.

In xl2003 menus:
Open excel
Tools|Customize|Commands Tab|Tools category
Search for "COM Add-ins"
Drag it to your favorite toolbar. (I placed it near the Addins... option under
the Tools menu.)

Close this customize dialog.
And click on Tools|COM Add-ins...
and see if you find anything that looks promising.