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.