Need to change the macro to make it run only for the second sheet of the excel

[nynamyna]

I have the following macro which works for the sheet that is open. I need to run this macro for the second sheet in my file when I click a button in first sheet..I have the button created but I am not able to run this from my first sheet.....can you please see this and tell me how to change it

Please Login or Register  to view this content.

[stnkynts]

After a quick peek at your code it looks like it is referencing the ActiveSheet for your processes. This may or may not be what you want to have happen as this is why it is only working on whichever sheet you have activated. A way around this, even though it is not the best, would be to put this code in the button that you have created:

Please Login or Register  to view this content.

Where 2 is the worksheet number that you want your macro applied to. There might be other quirks that come up but it should be ok. You could also set a loop to do every worksheet but i dont think that is what you wanted to do.

[nynamyna]

This works perfectly...
thank you very much