Stubborn toolbars in Excel

[007]

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.

 

[Craig]

is the toolbar attached to one of the files you are sharing?

Craig

 

[007]

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.

-------------------------------------------------

 

[Dave Peterson]

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??

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.

-------------------------------------------------

is the toolbar attached to one of the files you are sharing?

Craig

there's

 

[Dave Peterson]

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

http://google.com/[email protected]

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??

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.

-------------------------------------------------

is the toolbar attached to one of the files you are sharing?

Craig

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.

 

[007]

Thanks for your response Dave;
No I do not copy the user8.xlb book to other computers or users,
this is what I do before I take a file to another computer;
I delete the toolbars from;
1) attach\toolbars in the book and
2) from Customize\tool bars\delete.
I do this in both the regular file and in the user8.xlb file [application?]
and still the toolbars show up in the other users computer. They don't
appear the same as they presently are in my computer, but as they
were some months ago [I change icons once in a while to meet my
needs but leave the same toolbar names] .

This situation seems to be improving by now, I deleted most toolbars
in the way I said before, except for one toolbar which I want to keep,
and then copied a file to another computer by means of a diskette
obviously just one toolbar could have been carried enclosed in the file,
and it did, but not as it presently is, it appeared as it was about two
months ago, with the same name but with a difference in time.

There's one small detail I have noticed; if I change the name in the
user8.xlb file as Excel help says, in order to keep the toolbars as I want,
all customized toolbars seem to be deleted, but when I open another
file, which I have not "cleaned", all present and past toolbars appear,
but if I delete all the toolbbars I don't want and leave the user8.xlb
book alone, the changes seem to remain at least in this computer.

As to the vbs edition Jan Karel describes I don't know if it will apply
to a complete toolbar, and neither do i know how to modify it or
apply it. Any help with this?...


-------------------------------------------------

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

http://google.com/[email protected]

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??

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" <[email protected]> escribió en el mensaje
is the toolbar attached to one of the files you are sharing?

Craig

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]

Once you've shared that toolbar with the other pc, then that toolbar stays on
that other pc. You can clean up the toolbar (just like you did on your pc).

But say you have a toolbar attached to a workbook. You share that workbook with
me. Now I have that toolbar, too. If you go and remove the toolbar from the
workbook (or just change it), my toolbar doesn't change.

If you share that workbook with the new toolbar with me, my copy of excel
notices that I already have that toolbar with the same name. Since I already
have that toolbar (even though it's out of date), excel figures that it
shouldn't be messed with.

So my old toolbar still persists on my pc.

So if I deleted that toolbar from my pc, then you shared the new workbook, I'd
get the new toolbar (excel notices that I don't have it, so it uses the toolbar
that's attached).

Jan Karel's notes included a routine that cleaned up mechanically.

Stolen from Jan Karel's post:

....
After creating *or changing* the toolbar, you should
attach the toolbar to your workbook:

- activate the workbook to which you want to attach the toolbar
- Rightclick the toolbar, select 'customize'
- Click 'Attach' (Toolbars Tab)
- If the workbook already contains a toolbar by that name,
delete it first by clicking on it on the righthand side
and choosing Delete.
- Select your toolbar (on the left) and press 'copy'
- Save the workbook (optionally: save_as an add-in).

==========
Later he suggests this code:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("YourBarsName").Delete
End Sub

Load your workbook with that attached toolbar.
Modify the heck out of it.
Attach it to the workbook once more.

Then rightclick on the excel icon to the left of the File|Edit|View menu items
on the standard toolbar.
Select View Code
Paste that little snippet of code into that code window that you see.
(adjust the "YourBarsName" to what it really is in your workbook.)

alt-f11 to get back to excel.
Save your newly changed workbook.
Close this workbook.

Then check under Tools|customize|toolbars Tab
You won't see your toolbar anymore.
Reopen your workbook with the attached toolbar and check again. You'll notice
that that toolbar is back.



Now if you share this workbook with anyone, a couple of things can happen when
they open the workbook the first time:

1. If they have that old toolbar hanging around, they'll see that old toolbar.
2. If they don't have that old toolbar, they'll see the new one.

But when they close the workbook, the toolbar (old or new) will be removed.
Then the second time they open the workbook, they'll see the new toolbar.

=======
Just a word of warning. Each time you change that toolbar, make sure you
reattach it to the workbook. It ain't automatic.

Thanks for your response Dave;
No I do not copy the user8.xlb book to other computers or users,
this is what I do before I take a file to another computer;
I delete the toolbars from;
1) attach\toolbars in the book and
2) from Customize\tool bars\delete.
I do this in both the regular file and in the user8.xlb file [application?]
and still the toolbars show up in the other users computer. They don't
appear the same as they presently are in my computer, but as they
were some months ago [I change icons once in a while to meet my
needs but leave the same toolbar names] .

This situation seems to be improving by now, I deleted most toolbars
in the way I said before, except for one toolbar which I want to keep,
and then copied a file to another computer by means of a diskette
obviously just one toolbar could have been carried enclosed in the file,
and it did, but not as it presently is, it appeared as it was about two
months ago, with the same name but with a difference in time.

There's one small detail I have noticed; if I change the name in the
user8.xlb file as Excel help says, in order to keep the toolbars as I want,
all customized toolbars seem to be deleted, but when I open another
file, which I have not "cleaned", all present and past toolbars appear,
but if I delete all the toolbbars I don't want and leave the user8.xlb
book alone, the changes seem to remain at least in this computer.

As to the vbs edition Jan Karel describes I don't know if it will apply
to a complete toolbar, and neither do i know how to modify it or
apply it. Any help with this?...

-------------------------------------------------

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

http://google.com/[email protected]

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" <[email protected]> escribió en el mensaje
is the toolbar attached to one of the files you are sharing?

Craig

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.

 

[007]

Thanks Dave:

I will try the vbs code edition, but say I have other toolbars in the
same workbook; how would I edit the vbs code, ...

would the following be accurate;

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("toolbar1,toolbar2,toolbar3").Delete
End Sub

Thank you for your patience.
I hope this is my last request.


------------------------------------------------------

Once you've shared that toolbar with the other pc, then that toolbar stays on
that other pc. You can clean up the toolbar (just like you did on your pc).

But say you have a toolbar attached to a workbook. You share that workbook with
me. Now I have that toolbar, too. If you go and remove the toolbar from the
workbook (or just change it), my toolbar doesn't change.

If you share that workbook with the new toolbar with me, my copy of excel
notices that I already have that toolbar with the same name. Since I already
have that toolbar (even though it's out of date), excel figures that it
shouldn't be messed with.

So my old toolbar still persists on my pc.

So if I deleted that toolbar from my pc, then you shared the new workbook, I'd
get the new toolbar (excel notices that I don't have it, so it uses the toolbar
that's attached).

Jan Karel's notes included a routine that cleaned up mechanically.

Stolen from Jan Karel's post:

...
After creating *or changing* the toolbar, you should
attach the toolbar to your workbook:

- activate the workbook to which you want to attach the toolbar
- Rightclick the toolbar, select 'customize'
- Click 'Attach' (Toolbars Tab)
- If the workbook already contains a toolbar by that name,
delete it first by clicking on it on the righthand side
and choosing Delete.
- Select your toolbar (on the left) and press 'copy'
- Save the workbook (optionally: save_as an add-in).

==========
Later he suggests this code:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("YourBarsName").Delete
End Sub

Load your workbook with that attached toolbar.
Modify the heck out of it.
Attach it to the workbook once more.

Then rightclick on the excel icon to the left of the File|Edit|View menu items
on the standard toolbar.
Select View Code
Paste that little snippet of code into that code window that you see.
(adjust the "YourBarsName" to what it really is in your workbook.)

alt-f11 to get back to excel.
Save your newly changed workbook.
Close this workbook.

Then check under Tools|customize|toolbars Tab
You won't see your toolbar anymore.
Reopen your workbook with the attached toolbar and check again. You'll notice
that that toolbar is back.



Now if you share this workbook with anyone, a couple of things can happen when
they open the workbook the first time:

1. If they have that old toolbar hanging around, they'll see that old toolbar.
2. If they don't have that old toolbar, they'll see the new one.

But when they close the workbook, the toolbar (old or new) will be removed.
Then the second time they open the workbook, they'll see the new toolbar.

=======
Just a word of warning. Each time you change that toolbar, make sure you
reattach it to the workbook. It ain't automatic.

Thanks for your response Dave;
No I do not copy the user8.xlb book to other computers or users,
this is what I do before I take a file to another computer;
I delete the toolbars from;
1) attach\toolbars in the book and
2) from Customize\tool bars\delete.
I do this in both the regular file and in the user8.xlb file [application?]
and still the toolbars show up in the other users computer. They don't
appear the same as they presently are in my computer, but as they
were some months ago [I change icons once in a while to meet my
needs but leave the same toolbar names] .

This situation seems to be improving by now, I deleted most toolbars
in the way I said before, except for one toolbar which I want to keep,
and then copied a file to another computer by means of a diskette
obviously just one toolbar could have been carried enclosed in the file,
and it did, but not as it presently is, it appeared as it was about two
months ago, with the same name but with a difference in time.

There's one small detail I have noticed; if I change the name in the
user8.xlb file as Excel help says, in order to keep the toolbars as I want,
all customized toolbars seem to be deleted, but when I open another
file, which I have not "cleaned", all present and past toolbars appear,
but if I delete all the toolbbars I don't want and leave the user8.xlb
book alone, the changes seem to remain at least in this computer.

As to the vbs edition Jan Karel describes I don't know if it will apply
to a complete toolbar, and neither do i know how to modify it or
apply it. Any help with this?...

-------------------------------------------------

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

http://google.com/[email protected]

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" <[email protected]> escribió en el mensaje
is the toolbar attached to one of the files you are sharing?

Craig

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]

I'd edit the VBA code to look like:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("toolbar1").Delete
Application.CommandBars("toolbar2").Delete
Application.CommandBars("toolbar3").Delete
End Sub

If you have unrelated questions, you may want to post in a new thread.

If it's a followup, post back here. Then everyone will be able to see the
history and help out.

Thanks Dave:

I will try the vbs code edition, but say I have other toolbars in the
same workbook; how would I edit the vbs code, ...

would the following be accurate;

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("toolbar1,toolbar2,toolbar3").Delete
End Sub

Thank you for your patience.
I hope this is my last request.

------------------------------------------------------

Once you've shared that toolbar with the other pc, then that toolbar stays on
that other pc. You can clean up the toolbar (just like you did on your pc).

But say you have a toolbar attached to a workbook. You share that workbook with
me. Now I have that toolbar, too. If you go and remove the toolbar from the
workbook (or just change it), my toolbar doesn't change.

If you share that workbook with the new toolbar with me, my copy of excel
notices that I already have that toolbar with the same name. Since I already
have that toolbar (even though it's out of date), excel figures that it
shouldn't be messed with.

So my old toolbar still persists on my pc.

So if I deleted that toolbar from my pc, then you shared the new workbook, I'd
get the new toolbar (excel notices that I don't have it, so it uses the toolbar
that's attached).

Jan Karel's notes included a routine that cleaned up mechanically.

Stolen from Jan Karel's post:

...
After creating *or changing* the toolbar, you should
attach the toolbar to your workbook:

- activate the workbook to which you want to attach the toolbar
- Rightclick the toolbar, select 'customize'
- Click 'Attach' (Toolbars Tab)
- If the workbook already contains a toolbar by that name,
delete it first by clicking on it on the righthand side
and choosing Delete.
- Select your toolbar (on the left) and press 'copy'
- Save the workbook (optionally: save_as an add-in).

==========
Later he suggests this code:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("YourBarsName").Delete
End Sub

Load your workbook with that attached toolbar.
Modify the heck out of it.
Attach it to the workbook once more.

Then rightclick on the excel icon to the left of the File|Edit|View menu items
on the standard toolbar.
Select View Code
Paste that little snippet of code into that code window that you see.
(adjust the "YourBarsName" to what it really is in your workbook.)

alt-f11 to get back to excel.
Save your newly changed workbook.
Close this workbook.

Then check under Tools|customize|toolbars Tab
You won't see your toolbar anymore.
Reopen your workbook with the attached toolbar and check again. You'll notice
that that toolbar is back.



Now if you share this workbook with anyone, a couple of things can happen when
they open the workbook the first time:

1. If they have that old toolbar hanging around, they'll see that old toolbar.
2. If they don't have that old toolbar, they'll see the new one.

But when they close the workbook, the toolbar (old or new) will be removed.
Then the second time they open the workbook, they'll see the new toolbar.

=======
Just a word of warning. Each time you change that toolbar, make sure you
reattach it to the workbook. It ain't automatic.

Thanks for your response Dave;
No I do not copy the user8.xlb book to other computers or users,
this is what I do before I take a file to another computer;
I delete the toolbars from;
1) attach\toolbars in the book and
2) from Customize\tool bars\delete.
I do this in both the regular file and in the user8.xlb file [application?]
and still the toolbars show up in the other users computer. They don't
appear the same as they presently are in my computer, but as they
were some months ago [I change icons once in a while to meet my
needs but leave the same toolbar names] .

This situation seems to be improving by now, I deleted most toolbars
in the way I said before, except for one toolbar which I want to keep,
and then copied a file to another computer by means of a diskette
obviously just one toolbar could have been carried enclosed in the file,
and it did, but not as it presently is, it appeared as it was about two
months ago, with the same name but with a difference in time.

There's one small detail I have noticed; if I change the name in the
user8.xlb file as Excel help says, in order to keep the toolbars as I want,
all customized toolbars seem to be deleted, but when I open another
file, which I have not "cleaned", all present and past toolbars appear,
but if I delete all the toolbbars I don't want and leave the user8.xlb
book alone, the changes seem to remain at least in this computer.

As to the vbs edition Jan Karel describes I don't know if it will apply
to a complete toolbar, and neither do i know how to modify it or
apply it. Any help with this?...

-------------------------------------------------
"Dave Peterson" <[email protected]> escribió en el mensaje
And if you attach toolbars to workbooks, you'll want to read Jan Karel
Pieterse's notes:


http://google.com/[email protected]



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" <[email protected]> escribió en el mensaje
is the toolbar attached to one of the files you are sharing?

Craig

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.

 

[007]

Dave;
I will try this.. thank you very much for your help.

-----------------------------------------

I'd edit the VBA code to look like:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("toolbar1").Delete
Application.CommandBars("toolbar2").Delete
Application.CommandBars("toolbar3").Delete
End Sub

If you have unrelated questions, you may want to post in a new thread.

If it's a followup, post back here. Then everyone will be able to see the
history and help out.

Thanks Dave:

I will try the vbs code edition, but say I have other toolbars in the
same workbook; how would I edit the vbs code, ...

would the following be accurate;

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("toolbar1,toolbar2,toolbar3").Delete
End Sub

Thank you for your patience.
I hope this is my last request.

------------------------------------------------------

Once you've shared that toolbar with the other pc, then that toolbar

stays
on

that other pc. You can clean up the toolbar (just like you did on

your
pc).

But say you have a toolbar attached to a workbook. You share that workbook with
me. Now I have that toolbar, too. If you go and remove the toolbar

from
the

workbook (or just change it), my toolbar doesn't change.

If you share that workbook with the new toolbar with me, my copy of excel
notices that I already have that toolbar with the same name. Since I already
have that toolbar (even though it's out of date), excel figures that it
shouldn't be messed with.

So my old toolbar still persists on my pc.

So if I deleted that toolbar from my pc, then you shared the new

workbook,
I'd

get the new toolbar (excel notices that I don't have it, so it uses

the
toolbar

that's attached).

Jan Karel's notes included a routine that cleaned up mechanically.

Stolen from Jan Karel's post:

...
After creating *or changing* the toolbar, you should
attach the toolbar to your workbook:

- activate the workbook to which you want to attach the toolbar
- Rightclick the toolbar, select 'customize'
- Click 'Attach' (Toolbars Tab)
- If the workbook already contains a toolbar by that name,
delete it first by clicking on it on the righthand side
and choosing Delete.
- Select your toolbar (on the left) and press 'copy'
- Save the workbook (optionally: save_as an add-in).

==========
Later he suggests this code:

Private Sub Workbook_BeforeClose(Cancel as Boolean)
On Error Resume Next 'In case Toolbar is absent
Application.CommandBars("YourBarsName").Delete
End Sub

Load your workbook with that attached toolbar.
Modify the heck out of it.
Attach it to the workbook once more.

Then rightclick on the excel icon to the left of the File|Edit|View

menu
items

on the standard toolbar.
Select View Code
Paste that little snippet of code into that code window that you see.
(adjust the "YourBarsName" to what it really is in your workbook.)

alt-f11 to get back to excel.
Save your newly changed workbook.
Close this workbook.

Then check under Tools|customize|toolbars Tab
You won't see your toolbar anymore.
Reopen your workbook with the attached toolbar and check again.

You'll
notice

that that toolbar is back.



Now if you share this workbook with anyone, a couple of things can

happen
when

they open the workbook the first time:

1. If they have that old toolbar hanging around, they'll see that old toolbar.
2. If they don't have that old toolbar, they'll see the new one.

But when they close the workbook, the toolbar (old or new) will be removed.
Then the second time they open the workbook, they'll see the new toolbar.

=======
Just a word of warning. Each time you change that toolbar, make sure you
reattach it to the workbook. It ain't automatic.







007 wrote:

Thanks for your response Dave;
No I do not copy the user8.xlb book to other computers or users,
this is what I do before I take a file to another computer;
I delete the toolbars from;
1) attach\toolbars in the book and
2) from Customize\tool bars\delete.
I do this in both the regular file and in the user8.xlb file [application?]
and still the toolbars show up in the other users computer. They don't
appear the same as they presently are in my computer, but as they
were some months ago [I change icons once in a while to meet my
needs but leave the same toolbar names] .

This situation seems to be improving by now, I deleted most toolbars
in the way I said before, except for one toolbar which I want to keep,
and then copied a file to another computer by means of a diskette
obviously just one toolbar could have been carried enclosed in the file,
and it did, but not as it presently is, it appeared as it was about two
months ago, with the same name but with a difference in time.

There's one small detail I have noticed; if I change the name in the
user8.xlb file as Excel help says, in order to keep the toolbars as

I
want,

all customized toolbars seem to be deleted, but when I open another
file, which I have not "cleaned", all present and past toolbars appear,
but if I delete all the toolbbars I don't want and leave the user8.xlb
book alone, the changes seem to remain at least in this computer.

As to the vbs edition Jan Karel describes I don't know if it will apply
to a complete toolbar, and neither do i know how to modify it or
apply it. Any help with this?...

http://google.com/[email protected]

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" <[email protected]> escribió en el mensaje
is the toolbar attached to one of the files you are sharing?

Craig

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.