Daer all,

My workbook cointain54 sheets. i don't want to run all the macro to each
sheet.
Some descreption:
Sheet names in ascending order a Main, Content, Micro, Help, NN1,
NN2,....,NN50.
I have macros name: Main, Content, Micro1, Micro2, Help, NNA, NNB, NNC.
I have solved to run Main, Content, Micro and Help macro by following code.

Sheets("Sheet Name").Activate

But problem is for remaining Three Macro NNA, NNB and NNC.
NNA, NNB and NNC are
What i should put in a code, that runs my all three NN* macro through sheet
NN1 to NN50.


"Harshad" wrote:

My workbook cointain54 sheets.
Sheet names in ascending order a Main, Content, Micro, Help, NN1,
NN2,....,NN50.
I have macros name: Main, Content, Micro1, Micro2, Help, NNA, NNB, NNC.
I want to run specific macro on specific sheet as shown below, evenif what
ever sheet is active.
Macro Main & Content on sheet Main & Content respectively.
Macro Micro1 & Micro2 one by one on Sheet Micro.
Macro Help on sheet Help.
Macro NNA,NNB,NNC one by one on Sheet NN1 to Sheet NN50

Please sugest some code which i can put at the starting of specific macro so
that it can run.