Run existing macro (in module1) from new button (on a worksheet)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I've added a button onto one of the sheets I'm using and want it to point
towards a macro which currently sits in module1. I tried simply copy-pasting
it into the button click sub but it screws up. The macro is very long and I
have no idea how it works but just simply need to make the sheet more user
friendly for anybody who might use the sheet. Therefore, buttons.
 
I mean I've added a command button into one of the worksheets, not the button
 
Got it!

Place this on the on click event:

Call yourmacronamegoeshere

Regards,

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.
 
Worked a charm, cheers.

Michael said:
Got it!

Place this on the on click event:

Call yourmacronamegoeshere

Regards,

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.
Click to expand...
 
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

Put CommandButton1 code in Module1 3
Delete Sheet executing macro 3
Re: Reference must be to a macro sheet? 0
Macro runs fine from VBEditor, but not button 22
Method ‘CurrentPage’ of object ‘Pivot ‘Failed “ 2
Unable to assign macros to a new button in the current worksheet 1
Run two macros for two different sheets 11
Copy data using macro (with worksheet protect) 5

Back
Top