View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
raphiel2063 raphiel2063 is offline
external usenet poster
 
Posts: 47
Default Run existing macro (in module1) from new button (on a workshee

Worked a charm, cheers.

"Michael" wrote:

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.




"raphiel2063" wrote:

I mean I've added a command button into one of the worksheets, not the button
on the toolbar. So I don't have the option to just assign macro.

"Michael" wrote:

Did you right Click on the button and selected Assign Macro?
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"raphiel2063" wrote:

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.