I find that it sometimes helps to use

dim r as range
set r = activeworksheet.range(x)
r.select

Sounds as though one or more of the events are firing. You will presumably
get a "debug" option that can tell you which one.

However, easiest would be to answer "no" to "enable macros" when you open
the file. It should copy  OK then.

I am assuming that Excel is compiling the code embedded on the sheet
when it is copied. The error  is on the Range.Select code used to
move around the sheet.

This is an active form, so I need the macros active when it is
opened. The copy  is part of the process in using the form.

Any other thoughts?

Sorry, didn't gather that from your original question. It sounded as though
you were simply trying to copy  the sheet. I'm now slightly confused ... are
you copying the sheet  by hand, or is your code copying the sheet?

If it is code that is copying the sheet, just disable events before the copy
and turn them back on again after it. That should do the trick.