Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbars that only show up for a given worksheet.
I keep macros specific to a given worksheet inside the worksheet (not
in PERSONAL.XLS. I like to associate those macros to toolbar buttons. So far my toolbars end up globa (all workbooks can see them, even when the toolbar (and its associated functions) has nothing to do w/ the particular worksheet. How can I associate toolbars (along w/ its assigned macros) to a specific workbook. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbars that only show up for a given worksheet.
You could take the easy way out and have each of the subs in your workbook check
to see if the activeworkbook is one that should be able to run the code. if thisworkbook.name < activeworkbook.name then msgbox "Nope" exit sub end if at the top of each of your subs. ======== Another option would be to destroy the toolbar each time you deactivate the workbook and recreate it each time you activate the workbook. You'd use the workbook_activate event and the workbook_deactivate event. I would think that the code would look very similar to the code you use in the workbook_Open and workbook_beforeclose (or auto_open and auto_close) events. livetohike wrote: I keep macros specific to a given worksheet inside the worksheet (not in PERSONAL.XLS. I like to associate those macros to toolbar buttons. So far my toolbars end up globa (all workbooks can see them, even when the toolbar (and its associated functions) has nothing to do w/ the particular worksheet. How can I associate toolbars (along w/ its assigned macros) to a specific workbook. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i sort a worksheet data to show repetitve data and show | Excel Worksheet Functions | |||
How to show watermark in each worksheet? | Setting up and Configuration of Excel | |||
Show no toolbars in specific book | Excel Discussion (Misc queries) | |||
How do I hide and show all toolbars | Excel Worksheet Functions | |||
Hide/show worksheet | Excel Discussion (Misc queries) |