View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jason Jason is offline
external usenet poster
 
Posts: 367
Default Run a macro using a command button

Go to "View" & "Toolbars". Show the forms toolbar.

Click the "button" button. (I know it doesn't make sense, but if you hover
your cursor over, it will say "button")

You'll get a cursor where you can drag & drop a button.

Once you have the button, right click & choose "assign macro".

"Tdahlman" wrote:

I have created a macro using the Macro Recorder.
I have a command button and I want to run the macro (which is names
DATASORT) when I click the button.

Please advise how to make this work.

Thanks in advance,
Travis