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.
 
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...
 

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

Re: Reference must be to a macro sheet? 0
Macro runs fine from VBEditor, but not button 22
Unable to assign macros to a new button in the current worksheet 1
Run two macros for two different sheets 11
How to call Excel add-in macro from a button… 1
Prevent user from Inserting new worksheet 4
Hiding a macro button 2
Call Add-In Macro from VBA 3

Back
Top