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

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

That will probably work, its just more steps. I actualy recieve
report from five source workbook. I try to simplify the process as
much as possible so that when Im on vacation whoever is covering for
me doesnt have to think too much ;)
Thanks
Robert


On Jan 25, 5:33*pm, Dave Peterson wrote:
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

Maybe you can make it into a macro and then use that.

Robert H wrote:

That will probably work, its just more steps. I actualy recieve
report from five source workbook. I try to simplify the process as
much as possible so that when Im on vacation whoever is covering for
me doesnt have to think too much ;)
Thanks
Robert

On Jan 25, 5:33 pm, Dave Peterson wrote:
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

--

Dave Peterson