Attached tool bars

[WISE]

I have custom tools bars. When I attach the toolbar to the workbook and save.
I then open another workbook and the toolbar is there. I want a different
tool bar for each workbook. So if I have toolbar XXX-March attached to March
workbook when I open April bookbook XXX-March toolbar is attached. If I then
unattach XXX-MARCH and attach XXX-APRIL toolbar and save. If I then open
March, XXX-April toolbar is there. I thought toolbars are attached to a
workbook(sperate XLS file). Where am I going wrong.

[Eric_MUC]

Hi WISE,

not sure if this solves your issue but I had a similar one in the past.

Whenever you attach a toolbar to a workbook save the workbook and exit Excel.
Then restart Excel and the issue should be gone - as long as you are trying
to attach a toolbar to antother workbook and open another workbook in the
same "Excel session".
Therefore I always exit Excel before I want to attach or detach another
toolbar to another workbook.

I think is might be an issue with a sort of cache (?!) Excel's using...

Hope, this helps you - best wishes,
Eric


"WISE" wrote:

> I have custom tools bars. When I attach the toolbar to the workbook and save.
> I then open another workbook and the toolbar is there. I want a different
> tool bar for each workbook. So if I have toolbar XXX-March attached to March
> workbook when I open April bookbook XXX-March toolbar is attached. If I then
> unattach XXX-MARCH and attach XXX-APRIL toolbar and save. If I then open
> March, XXX-April toolbar is there. I thought toolbars are attached to a
> workbook(sperate XLS file). Where am I going wrong.

[WISE]

Thank you for the quick response. I have retried this many times. I'm using
MS Excel 2003 SP1. I do not know if this is a bug or something. Very
frustating. I open one xls and attach the toolbar and save/close then go open
another workbook and there is the toolbar. Even if I open excel and create a
new workbook with nothing open there is the toolbar attached to the new
workbook.

/Randy

"Eric_MUC" wrote:

> Hi WISE,
>
> not sure if this solves your issue but I had a similar one in the past.
>
> Whenever you attach a toolbar to a workbook save the workbook and exit Excel.
> Then restart Excel and the issue should be gone - as long as you are trying
> to attach a toolbar to antother workbook and open another workbook in the
> same "Excel session".
> Therefore I always exit Excel before I want to attach or detach another
> toolbar to another workbook.
>
> I think is might be an issue with a sort of cache (?!) Excel's using...
>
> Hope, this helps you - best wishes,
> Eric
>
>
> "WISE" wrote:
>
> > I have custom tools bars. When I attach the toolbar to the workbook and save.
> > I then open another workbook and the toolbar is there. I want a different
> > tool bar for each workbook. So if I have toolbar XXX-March attached to March
> > workbook when I open April bookbook XXX-March toolbar is attached. If I then
> > unattach XXX-MARCH and attach XXX-APRIL toolbar and save. If I then open
> > March, XXX-April toolbar is there. I thought toolbars are attached to a
> > workbook(sperate XLS file). Where am I going wrong.

[Eric_MUC]

Hi Wise,

aaahhh...I think I now know what's your problem.

Are you aware of the following?

Whenever you open a workbook in Microsoft Excel which has a toolbar attached
- this toolbar will be aaded to the Microsoft Excel toolbars collection and
won't be removed after you closed the workbook.
A toolbar will be there (in MS Excel) as long as you delete(!) it manually.
But it will not be automatically attached to another workbook - it will
simply stay in MS Excel as long as you finally delete it.

A solution might be to add a VBA-macro which deletes the toolbar again when
closing the workbook.

Best wishes,
Eric

"WISE" wrote:

> Thank you for the quick response. I have retried this many times. I'm using
> MS Excel 2003 SP1. I do not know if this is a bug or something. Very
> frustating. I open one xls and attach the toolbar and save/close then go open
> another workbook and there is the toolbar. Even if I open excel and create a
> new workbook with nothing open there is the toolbar attached to the new
> workbook.
>
> /Randy
>
> "Eric_MUC" wrote:
>
> > Hi WISE,
> >
> > not sure if this solves your issue but I had a similar one in the past.
> >
> > Whenever you attach a toolbar to a workbook save the workbook and exit Excel.
> > Then restart Excel and the issue should be gone - as long as you are trying
> > to attach a toolbar to antother workbook and open another workbook in the
> > same "Excel session".
> > Therefore I always exit Excel before I want to attach or detach another
> > toolbar to another workbook.
> >
> > I think is might be an issue with a sort of cache (?!) Excel's using...
> >
> > Hope, this helps you - best wishes,
> > Eric
> >
> >
> > "WISE" wrote:
> >
> > > I have custom tools bars. When I attach the toolbar to the workbook and save.
> > > I then open another workbook and the toolbar is there. I want a different
> > > tool bar for each workbook. So if I have toolbar XXX-March attached to March
> > > workbook when I open April bookbook XXX-March toolbar is attached. If I then
> > > unattach XXX-MARCH and attach XXX-APRIL toolbar and save. If I then open
> > > March, XXX-April toolbar is there. I thought toolbars are attached to a
> > > workbook(sperate XLS file). Where am I going wrong.