hi,
I don't know if this has anything to do with it but is the
macro a sheet macro. that is a macro assigned to a sheet
and not the workbook or general.
I have never encountered this problem before. i usually
use button on the sheet to fire the macros.

-----Original Message-----
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
.