Is this worksheet one that other people use and need to use the macros as well?

If not, then I would suggest saving the macros on your personal macro file,
which means they would be accessable only on that computer.

"Lisa" wrote:

Hi all -

When I copy a worksheet, I need to be able to use the same macros for the
new sheet. The problem I am having is that when I go to the newly copied
sheet, and run the macro, it goes back to the previous sheet. Is there a way
to have the macro reference the new sheet?