Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Toolbar Button
I am using Excel 2002.
I have written a macro, assigned it a custom button and put the button on my toolbar. No problems here, it all works as planned. However, this same macro button shows up on every workbook I open. Is there a way to have this button only show up on the specific wookbook it is intended for and not all others? Much Thanks, Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Toolbar Button
However, this same macro button shows up on every workbook I open.
Toolbuttons belong to Excel, not to a specific workbook (even if they are attached to a workbook). However, you can get the result you want with some fancy macro work. It's possible to have code run when your workbook is activated and deactivated that can make the toolbutton hide/show, etc. http://support.microsoft.com/default...61&Product=xlw http://www.cpearson.com/excel/events.htm -- Jim Rech Excel MVP "Gary" wrote in message ... |I am using Excel 2002. | | I have written a macro, assigned it a custom button and | put the button on my toolbar. No problems here, it all | works as planned. However, this same macro button shows | up on every workbook I open. Is there a way to have this | button only show up on the specific wookbook it is | intended for and not all others? | | Much Thanks, | Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro button on toolbar | Charts and Charting in Excel | |||
Button with macro in toolbar | Charts and Charting in Excel | |||
Command Button for Macro on a Toolbar | Excel Discussion (Misc queries) | |||
Macro button on toolbar | Excel Discussion (Misc queries) | |||
Toolbar button To Run a Macro? | Excel Programming |