Maybe you can copy|paste special values into a newly created worksheet--instead
of copying the worksheet itself????

Robert H wrote:

I have a workbook that generates summary data from data validation
lists and formulas. Once the data is set a macro is ran that creats a
"clean" sheet preplacing the formulas etc with just the values, then
removes all names from the clean sheet. The clean sheet is moved to a
new workbook by right clicking the tab and selecting the new
notebook... The problem is that the global names in the source
notebook get copied to the new notebook. Is it possible to move the
clean sheet so that it is realy "clean".

thanks
Robert

--

Dave Peterson