buttons are different

[jefe]

I have added four buttons to a sheet. Three of them seem
to be similar while the last one is a command button.
When I right click on the first three I get different
options than on the fourth. I want the last one to be the
same but I can not figure out what I did differently. I
want to be able to assign a macro to it like I did the
first three but I can't seem to get there.

Any ideas where I may have gone wrong? how I might change
it?

Thanks

 

[JE McGimpsey]

You added the fourth button from the Controls toolbar instead of hte
Forms toolbar.

Delete the button and add another from the Forms toolbar.

 

[papou]

Hi jefe
You must have used two different tools to create your buttons :
Forms ToolBar
Controls ToolBox

HTH

Regards
Pascal

 

[jefe]

Is there a functional difference between the control and
form buttons?

TIA

 

[JE McGimpsey]

You discovered one - Forms controls can have macros attached, Control
toolbar controls are ActiveX components that have events that can
trigger event macros. They are also much more customizable than forms
buttons. OTOH, Forms buttons are cross-platform compatible, Control bar
buttons aren't.