| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy worksheet without names
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
| Copy worksheet containing names to other workbook w/o problems? | Excel Discussion (Misc queries) | |||
| Copy worksheet with named ranges to new workbook and keep names | Excel Worksheet Functions | |||
| Copy names to new worksheet | Excel Worksheet Functions | |||
| Worksheet copy problem - local names | Excel Discussion (Misc queries) | |||
Threaded Mode
