Macro running on active sheet instead of sheet defined in macro

Hi, I am having a problem with a macro that is supposed to run on a specific sheet(s) defined in the macro but is instead running on the active sheet and not the defined sheet(s). Can someone help me with this please? In the specific instance, there are 4 defined sheets but in other workbooks, I have as few as one. If the active sheet is one of the defined sheets I don't seem to have an issue but if I am on a sheet the macro should ignore, it still runs which is causing me problems. I could add a Worksheet.select but then I end up on a different tab every time I save (I have my macros running in a BeforeSave) which is less than ideal. Please help! Thanks.

Please Login or Register  to view this content.

You don't fully reference ranges in your code everywhere. For example this

Please Login or Register  to view this content.

should probably be like this

Please Login or Register  to view this content.

edit: unqualified references will always refer to active objects. Like active workbook, active worksheet, etc.

Thank you!!

Glad to help.