Excel: Ensuring Macros only Affect the Active Sheet

Hi Folks: I store the majority of my macros in my personal macro workbook/file. Is the a way to ensure that when I run a macro that it only affects the ActiveSheet? My second question is how to identify the WS that I want the macro to run in when storing macros in my personal macro workbook for times when i may not have the active sheet open? Thank you for reading and any advice.

This question generated 19 answers. To proceed to the answers, click here.

This thread is current as of March 30, 2017.

For more resources for Microsoft Excel