You could have code which activates when a workbook opens.
The code would add the macro as a button to the toolbar.

A condition within the code would check to see if the workbook is a certain
name, which would determine whether to add to the toolbar.

I have toolbar button examples on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Edgar" wrote in message
...
Hi,
I have a macro on personal workbook and have it visible
on the toolbars.

I would like have it made enable and visible only when I
open a specific worksheet and not otherwise.

I am using excel 2002

pls advice