Hi,

Thanks for all the help.

It is a Forms button.
I used the control toolbox to create the button adn I do get all those
option when right clicking on it in design mode.
Under properties I gave it the name 'makebusy'.

Thanks again for all the help.

On Nov 21, 1:05 am, OssieMac
wrote:
Hi,

There are two types of buttons. Need to know what type. One is created from
the Forms toolbar and the other is and ActiveX control created from the
Control Toolbox toolbar. (Both look alike)

Right click on the button.

If you get a dialog box with a number of options including Cut, Copy Paste
etc then it is a Forms button.

If nothing happens or only a dotted line around just inside the perimeter,
it is an ActiveX control.

Let me know what type of button you have and I'll provide sample code and
instructions on how to identify the button name for the code.

--
Regards,

OssieMac



" wrote:
I just want to add that the button is not created with Auto_open sub.
It is already in the spreadsheet. I just want to make sure that the
caption is changed to "start"
Thanks