Run Macro from Command Button

  • Thread starter Thread starter stevefrancis
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

losing command button functionality 4
Access Automatically Send a notification email once a record is added 0
'Cannot insert object' message when I try to put a button on a worksheet 7
Run a macro using a command button 9
Help to create a macro 2
Command button macro 6
Alt+F11, writing macros and assigning to a button 2
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1

Back
Top