I am trying to copy and paste named cells from one workbook to another
without having the first workbook file name attach to the named cells. For
example, I am copying a cell named XYZ from file One.xls to file Two.xls. I
need to have cell XYZ NOT say One.xls!XYZ when it is entered into Two.xls.
Also, how can I get that message that asks if I want to use the cell names to
not pop up?