Make a macro run on only a specified worksheet regardless of which sheet is active.

Hi all,

I'm aware that this may seem like a pretty simple issue, but i was wondering what coding is required to ensure that a Macro only runs on a sheet with a specific name regardless of which sheet it currently active?

The Macro is fairly simple in nature as it is sorting columns etc and I have managed to get the macro working correctly so long as the sheet in question is currently active.

The eventual aim is to have an additional macro that will run a series of macros each relating to one specific sheet. I have discovered that in order to do this i first need to ensure that each macro can only run on the 1 sheet it is designed for.

This is an obstacle that i'm sure is simple enough to overcome but am currently having no luck.

Any help would be appreciated.

Thank you.
Ethan

You could use the following:

Please Login or Register  to view this content.

Thanks Estratosphere. Would that code go at the very beginning of my macro

Please Login or Register  to view this content.

Yes it would. Will stop the active sheet changing but run the macro, in place of the .select line

Excellent.

Thank you both for your advise/feedback. It's very much appreciated.
Have a good evening both.

Regards
Ethan