| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to create a new worksheet that is a copy of an existing one? | Excel Programming | |||
| Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template. | Excel Programming | |||
| Module1 vs Thisworkbook for Macro | Excel Programming | |||
| How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming | |||
| Excel open an existing MS Query in edit mode via macro attached to a button. | Excel Programming | |||
Hybrid Mode
