Attached tool bars

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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