How do you make a clickable button without creating a form?

[stubarny]

Hello everyone,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Please could you tell me how to create a clickable button without creating a form?
<o> </o>
Clicking the button should invoke a macro and also change the appearance of the button so that it appears to have been physically pressed.
<o> </o>
Many thanks for your help.
<o> </o>
Stu

 

[GTO]

Where are we putting the button, on a worksheet?

 

[dmb41]

http://support.microsoft.com/kb/141689

 

[Kenneth Hobson]

I guess that you mean on the worksheet as GTO said. To explain in detail, we would need to know your Excel version.

You can add one by a Form Control button or an ActiveX command button. In Excel 2010, add the Developer tab to the ribbon by right clicking the ribbon and selecting it. Click the down arrow on the Insert button on that tab and pick one of the two controls. The form control will prompt for a macro to assign to it when you create it. The doubleclick the ActiveX control to add the name of the macro to run in the Sub or add code.

 

[stubarny]

Hi guys, the Excel version is 2003.

 

[Glory]

Right-click where all your toolbars are at the top of the screen. Click "Control Toolbox". A new toolbar will appear.

Click the button icon. It will allow you to draw a clickable button on your worksheet.

You can view the code by clicking another button on that same new toolbar. Hover over all the buttons to see what they're for.

 

[GTO]

...answered