RE: Button to call a Macro ?

[Dhimit]

RE: Button to call a Macro ?

Hi,

Is it possible to place a BUTTON on a worksheet to call a Macro as opposed to using a 'shortcut key' ?

Dhimit

 

[Lewiy]

Certainly is!!
Go to View>Toolbars>Forms.
Pick the button from this toolbar and place it on the worksheet, the macro dialog will open automatically from where you can select the macro you want it to run.

 

[ADAMC]

Yes....By worksheet button i assume you mean a button from the forms menu:

On the forms menu click button:
Go to the worksheet and place the button where you want it to be placed, Excel by default will ask you if you wish to assign a macro to this button.

If you dont have the forms menu.....

Tools > Customize > Toolbars > pick forms from the list,

 

[Peter_SSs]

Dhimit

There is also a Command Button on the "Control Toolbox" toolbar that can also be used for this pupose - though in a slightly different way. Post back if you need further help.