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

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.

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

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.

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

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.

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

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.

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.