Do any of these names exist  in the workbook? Look at Insert/Names/Define to
find them. If they point to cells on the w/s you are copying there will be an
issue.

As far as I can find  using either f(5) or IND I can find none of the names
in the workbook  or the worksheet. One of the names I would never use myself
and that one is "wrn.controlled._.shipping._.orion". I have no idea where
that name would come from unless it was generated by the program  itself
somewhere. I will continue looking for the various names that show up by
looking at each worksheet  in the workbook (9 worksheets) and also looking
into the buttons and macros that are in the workbook.



Any other suggestions  on how to resolve this issue?

wrn* is a system generated name, there are a few of them.

Also, names can be hidden, so you don't see them in the built-in Name
Manager.

You should get hold of a copy  of Jan Karel Pieterse's free addin
NameManager utility http://www.jkp-ads.com/officemarketplacenm-en.asp
which will help you enormously with names.

I haven't been able to duplicate the symptoms.. although I haven't spent a LOT
of time  on it.
Have you tried setting Application.DisplayAlerts = false (remember to set it to
True after you've copied the worksheet).
This MIGHT cause the popup to be disabled... it doesn't work for things like
locked cell warnings, but it might work for this.

What if Pat uploaded his file? I would think one of us might be able to
figure it out if we got our hands on the actual workbook...

In the meantime I found a work around to the problem  (always more than one
way to do things). What I have done is to add a new worksheet  in the
position I wanted to copy  the old one. I then copied the data from the
original worksheet (cells.select, copy) and then used a similar command on
the new worksheet (cells.select) so I am selecting the entire worksheet. I
then use Paste special to paste all the information from the old worksheet
to the new one. I then go back  to the old worksheet and use paste
special.values to clear out all the formulas on the old worksheet.



Using this method, with several additional steps that wouldn't be needed if
the "right" method worked, I am able to do what I need.



Please look at the old file and see if you can find  what is needed so I
don't run into this problem the next time  I want to copy or move  a
worksheet. Since I found a method that works  I can at least put this
problem on the back burner and finish other problems I have.



Thanks to all for the suggestions  and help.



I did download the suggested utility for finding named ranges but need to
work with it more to understand what it is trying to tell me.