How to keep names defined after a copy?
 

Hi,
I have defined a sheet model, which contains several defined names. Some of
these names are used in formulas in cells of the same sheet and the remaining
names will be used later when this model is copied to one other workbook.
When I copy this model, by program using VBA Copy and Paste commands, I lost
all defined names which are not used in the same sheet of the model, and the
others names remain defined.
Why Microsoft Excel removes these names ? Is there any solution to keep
these names defined after a copy?
Thanks for any suggestion.