Macro Toolbar Button

[Gary]

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

 

[Jim Rech]

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.aspx?scid=kb;en-us;161761&Product=xlw

http://www.cpearson.com/excel/events.htm


--
Jim Rech
Excel MVP
|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