And if you attach toolbars to workbooks, you'll want to read Jan Karel
Pieterse's notes:

http://google.com/groups?threadm=083...0a% 40phx.gbl



Dave Peterson wrote:

I'm not sure if this will help...

You can customize toolbars (usually manually via tools|customize). These
changes are saved in a file named *.xlb (name and location vary with versions of
excel and windows. These are not usually shared with others (well, unless you
copy the *.xlb and overwrite their customized settings.

But toolbars can be built on the fly. Workbooks can have code that create
toolbars whenever they open. Most (some?) workbooks clean up after themselves.
When you close the workbook, it deletes the toolbars it created.

And finally, toolbars can live in individual workbooks. If you've attached a
toolbar to a workbook (via tools|customize|toolbars tab|attach button), you can
delete them from that same workbook using the same menu options. But make sure
you save that workbook (w/o the attached toolbar) or you'll have to do it again.

But when you created this toolbar (that you attached), you have updated your
*.xlb to contain it, too.

Deleting that toolbar from the individual workbook could have left it in your
toolbar collection.

Tools|customize|toolbars tab
select that toolbar
click delete

So I think the question boils down to: How is that toolbar coming back?

1. Is it just becoming visible (and has always been there)
2. Or is it being built on the fly (and not being cleaned up later)
3 Or is it attached to a workbook that you didn't clean up (and save)

Any help??

007 wrote:

Hi Craig: The toolbars are programmed on my computer, every
excel file I create shows the toolbars I have created, and when I
share files to other users and computers, the toolbars show up there,
it would be expected that customized toolbars should only apply to
the creator, not to other users as it is the case. As I understand, you
can program the toolbars on a particular excel file and after closing it,
you then change the name on the excel8 (or user8 file if on a network)
and the toolbars should show from there on as you organized them,
and they should show only on the creator's account, well this is not so,
those toolbars spread like an infection to other computers and users
by way of shared files and there is no way of getting rid ot them, I delete
them in Customize Toolbars\attach[or enclose]\toolbars in the book and
also in Customize\Toolbars\Delete, and before long, they show up again,
and today, they even appeared as they were some months ago.

There must be a way to fix this, Excel help says you can only restore
default toolbars to original state but cannot delete created ones,
if that is so, what is the delete toolbars button for... and they do indeed
delete with the button but not permanently they keep restoring and at
times they restore to a time in the past to the way they were customized
and saved then.
This must be a problem Microsoft should look into or they should not include
the option to customize toolbars because it seems it cannot be undone.

I have had trouble in the past with the system administrator because of
this, but there's nothing I can do to stop this from recurring. Someone
told me I have to delete the toolbars from every file I have but somehow
it doesn't seem logical to me. There must be a way to program Excel without
the toolbars on the computer instead of going through each file.

To concretely answer your question, I delete the customized toolbars before
I share files to prevent them from spreading to other computers and users,
but they do appear anyway on their computers.

I would appreciate any help.

-------------------------------------------------
"Craig" escribió en el mensaje
...
is the toolbar attached to one of the files you are sharing?

Craig

"007" wrote in message
...
Hi group:

Does anyone know how to permanently delete customized toolbars in
Excel?.... The problem is that some time ago, I created new toolbars
to make the use of excel faster, later I deleted those bars and created
new
ones, and after having deleted the prior ones, they came back and now
I can't delete any of the bars I have created, the only option is to
hide
them
because there's no way to delete them... there's a button to delete them
but they allways return unexpectedly particularly when I share files,
they
appear on other computers and it seems like an infection that cannot be
erradicated. In Excel Help it says they cannot be deleted, but if
there's
a
button to delete them and they dont delete, what is the purpose of that
button.
This seems to me like a defect in Excel ... and a very problematic one
because
I get remarks from people I share files with.
There should be a solution for this problem somewhere.

Does anyone know the solution to this problem?...

Thanks for your help.





--

Dave Peterson

--

Dave Peterson