hi, michelle !
I am attempting to copy a sheet that has several named ranges.
Each time I have to select whether to keep the names as defined or rename them.
Is there a setting that will override this and keep the ranges each time I copy the sheet?
1) AFAIK, this type of 'conflicts' arises -only- when you are copying...
a) formulae between worksheets [same workbook] with identical names
b) worksheets into other workbooks that has identical names
2) named-ranges they have two scopes:
a) global [workbook-level] as the first time you define/create/... the name
b) local [worksheet-level] when you copy worksheets within the same workbook
[or fully-qualifying with the sheet-name while defining the name]
3) when you copy entire worksheets within the same workbook...
excel [usually] can *handle* this issue creating a *new* set of local names referring to the *new* sheet
if you are performing actions as per 1-a) and/or 1-b)
[i guess] you could use macros setting to false Application.DisplayAlerts
turning it back to true after completing your copy-actions -?-
hth,
hector.