Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Woorkbook toolbar
Hello,
I tried creating a custom toolbar for a workbook with a button to execute a macro. It appeared to be working but now I notice that once the workbook is used once the toolbar appears in Excel for all other workbooks? I only want it attached to the selected workbook in question which I thought was the point of doing the attach part of the toolbar creation. What am I missing? Thank you, QB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Woorkbook toolbar
I did some reading/searching online and found info where I needed to create
an BeforeClose event that deletes the CommandBar before closing the workbook. Is this the right approach? If it is attached to the workbook why should I delete it everytime it it used? I figure I am missing something simple. Thank you, QB "Question Boy" wrote: Hello, I tried creating a custom toolbar for a workbook with a button to execute a macro. It appeared to be working but now I notice that once the workbook is used once the toolbar appears in Excel for all other workbooks? I only want it attached to the selected workbook in question which I thought was the point of doing the attach part of the toolbar creation. What am I missing? Thank you, QB |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Woorkbook toolbar
That is how I do it. You create the toolbar on open and delete it on close.
Moreover you hide it when the user selects a different workbook and make it visible when they return. It is not really that bad to do but you can't just record a macro to do it. Check out this link on events programming... http://www.cpearson.com/excel/Events.aspx And this one on commandbars... http://www.rondebruin.nl/menuid.htm -- HTH... Jim Thomlinson "Question Boy" wrote: I did some reading/searching online and found info where I needed to create an BeforeClose event that deletes the CommandBar before closing the workbook. Is this the right approach? If it is attached to the workbook why should I delete it everytime it it used? I figure I am missing something simple. Thank you, QB "Question Boy" wrote: Hello, I tried creating a custom toolbar for a workbook with a button to execute a macro. It appeared to be working but now I notice that once the workbook is used once the toolbar appears in Excel for all other workbooks? I only want it attached to the selected workbook in question which I thought was the point of doing the attach part of the toolbar creation. What am I missing? Thank you, QB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect single sheets in the woorkbook | Excel Worksheet Functions | |||
TAB NAME IN A WOORKBOOK REFER TO A CELL ON WORKSHEET | Excel Discussion (Misc queries) | |||
How do I create a backup woorkbook in Excel 2003. | Excel Discussion (Misc queries) | |||
Adjusting toolbar size, restore toolbar | Excel Discussion (Misc queries) | |||
woorkbook | Excel Worksheet Functions |