Saving Toolbars/CommandBars

J

Jim Rech

Can you elaborate on what you mean, perhaps with an example?

--
Jim Rech
Excel MVP
| How can I force the saving of a toolbar/commandbar in
| Excel 2000?
|
| Thanks,
| Don
 
D

Don A.

I have a toolbar I bring ".visible=true" when I open a
workbook and ".visible=false" when I close it. However,
sometimes any changes I make to the toolbar aren't saved
when I close excel. I changes the face and caption of
some controls when I change the workbook.
 
J

Jim Rech

It sounds as if you've attached your toolbar to your workbook. When you
attach a toolbar to a workbook using the Toolbars, Customize feature you are
saving a snapshot of that toolbar at that point in time. Excel never
updates that snapshot on its own no matter how many changes you make to it.
You must use Toolbars, Customize again any time you want a snapshot of the
current toolbar to replace the old one in the workbook. There is no way I
know of to do this by macro.

Something else you should be aware of using the "attach" method. Say you
give someone a copy of your workbook and he opens it. He now has a copy of
your toolbar in his permanent toolbar set (even if you hide it when the
workbook is closed).

Now let's say that you make changes to your toolbar and re-attach it to your
workbook. Now when this other person opens your new workbook he will still
see the old toolbar, not the new one. The reason is that when there is
already a toolbar with a given name, Excel ignores an attached toolbar with
the same name. For that reason you should always delete your toolbar when
your workbook closes. Hiding it is not enough.

--
Jim Rech
Excel MVP
|I have a toolbar I bring ".visible=true" when I open a
| workbook and ".visible=false" when I close it. However,
| sometimes any changes I make to the toolbar aren't saved
| when I close excel. I changes the face and caption of
| some controls when I change the workbook.
| >-----Original Message-----
| >Can you elaborate on what you mean, perhaps with an
| example?
| >
| >--
| >Jim Rech
| >Excel MVP
| message
| >| >| How can I force the saving of a toolbar/commandbar in
| >| Excel 2000?
| >|
| >| Thanks,
| >| Don
| >
| >
| >.
| >
 
Top