I am working in Excel 2003.

I have asigned a macro to a customer toolbar button which
is only available when a certain sheet in the workbook is
open. This button is on the standard toobar. I was able
to do this with the Worksheet_Activate and
Worksheet_Deactivate subroutines.

I made took the smiley face button from
View/Toolbars/Commands/Macros and drug it to the standard
toolbar. I did not create my own button.

On worksheet deactivation, the standard toolbar is reset
and the custom macro button goes away. However, each
time I reactivate the sheet and the button is placed back
on the toolbar, I have to reassign the macro to it and
also change the name from "Custom Buttom".

How do I get the custom button to retain its name and the
macro assigned to it?

Thanks,
Gary