Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attached tool bars
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attached tool bars
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attached tool bars
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Attached tool bars
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disappearing Tool and menu bars | Excel Discussion (Misc queries) | |||
Disabling tool bars | Excel Discussion (Misc queries) | |||
Lost all my menu bars and tool bars | Excel Discussion (Misc queries) | |||
How do I restore my menu and tool bars in Excell? | Excel Discussion (Misc queries) | |||
Worksheets open behind tool bars | Excel Discussion (Misc queries) |