Run Macro from Command Button

S

stevefrancis

Hi

Nice simple one thats driving me mad !

I have created a macro in an Excel worksheet that I want to be able to
run by clicking a command button on the same worksheet.I just cant
seem to be able to find how to do it.

I have created the new button on the sheet by the way.

The macro is called PrintMe.

Thanks v.much in advance

Steve
 
P

PCLIVE

Right-click your button. If it shows View Source, then select that.
Then in the source code, simply put:

PrintMe

Should work fine. If when you right-click you see 'Assign Macro', well that
will be obvious what to do.

HTH,
Paul
 
Top