Is it possible to run a different VBA procedure to different worksheets on a shortcut key

[edlim85]

Hihi,

I am new and just started on excel VBA.

Say i have many worksheets in say book1.xlsm and each worksheet have its own set of unique vba procedures. Can I run everything at once ie with a short cut key?

if yes, I will need some guide to go about doing it
-Do I write my codes in each worksheet?
-or put all my codes in a module and use "if then statement" to find the worksheet to run a particular procedure to that worksheet

Pls advise.

Regards
Edmund

 

[bensonsearch]

Hihi,

I am new and just started on excel VBA.

Say i have many worksheets in say book1.xlsm and each worksheet have its own set of unique vba procedures. Can I run everything at once ie with a short cut key?

if yes, I will need some guide to go about doing it
-Do I write my codes in each worksheet?
-or put all my codes in a module and use "if then statement" to find the worksheet to run a particular procedure to that worksheet

Pls advise.

Regards
Edmund

Hi,
if the macro (code) is the same for each sheet then one macro is needed on the whole workbook. in saying that shortcut yes. go to View then click macros/view macros. highlight the one you want and goto options. on the little screen there s shortcut which is Ctrl + something you want.

press ok

 

[villy]

You can do run different code but one at a time..let say

In one marco..

Sub RunAll()
Call Macro1
Call Macro2
Call Macro3
...so on
End Sub

 

[edlim85]

Sub RunAll()Call Macro1Call Macro2Call Macro3...so onEnd Sub</PRE>
Each macro is different, in other words unique to a specific worksheet. i'll try using the call function above.

cheers and thanks guys.