Permanently Changing a Toolbar
 

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?

Permanently Changing a Toolbar
 

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.

Mark P wrote:
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?

Permanently Changing a Toolbar
 

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



On Thu, 22 Jan 2009 15:36:43 -0500, Riccol wrote:

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.

Mark P wrote:
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?

Permanently Changing a Toolbar
 

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 wrote:
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

Permanently Changing a Toolbar
 

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 ToolsOptionsGeneral "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

On Thu, 22 Jan 2009 17:49:16 -0500, Riccol wrote:

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 wrote:
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

Permanently Changing a Toolbar
 

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 wrote:
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 ToolsOptionsGeneral "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.

Permanently Changing a Toolbar
 

I'm out of ideas.

Could even be a *.dll that Avery installs.


Gord

On Thu, 22 Jan 2009 18:25:47 -0500, Riccol wrote:

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 wrote:
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 ToolsOptionsGeneral "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.

Permanently Changing a Toolbar
 

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.



Riccol wrote:

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 wrote:
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 ToolsOptionsGeneral "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.

--

Dave Peterson