Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ReOrder Excel Objects.
After deleting and adding worksheets, I see in VBA, the MS Execl Objects are
ordered thus: Sheet1(First sheet) Sheet3(Second sheet) Sheet6(Third Sheet) How do I rebuild this file so that the sheets a Sheet1(First sheet) Sheet2(Second sheet) Sheet3(Third Sheet) The sheets have named lists and other references between sheets that must me maintained. I tried the 'Move or Copy..' but that maintained the Sheet* number. I tried to create a new workbook and cop the cells, but that lost all the Named list references. I'm doing this because I'm building a master template and want it 'clean' and in order. And I'm trying to avoid redoing all the lists, etc. Any other ideas? Thanks, John S. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ReOrder Excel Objects.
Change the codenames of the sheets. This is the property "(Name)", as
opposed to "Name", in the VB Editor's Property pane. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "DocBrown" wrote in message ... After deleting and adding worksheets, I see in VBA, the MS Execl Objects are ordered thus: Sheet1(First sheet) Sheet3(Second sheet) Sheet6(Third Sheet) How do I rebuild this file so that the sheets a Sheet1(First sheet) Sheet2(Second sheet) Sheet3(Third Sheet) The sheets have named lists and other references between sheets that must me maintained. I tried the 'Move or Copy..' but that maintained the Sheet* number. I tried to create a new workbook and cop the cells, but that lost all the Named list references. I'm doing this because I'm building a master template and want it 'clean' and in order. And I'm trying to avoid redoing all the lists, etc. Any other ideas? Thanks, John S. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ReOrder Excel Objects.
Perfect! Thanks!
John "Jon Peltier" wrote: Change the codenames of the sheets. This is the property "(Name)", as opposed to "Name", in the VB Editor's Property pane. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "DocBrown" wrote in message ... After deleting and adding worksheets, I see in VBA, the MS Execl Objects are ordered thus: Sheet1(First sheet) Sheet3(Second sheet) Sheet6(Third Sheet) How do I rebuild this file so that the sheets a Sheet1(First sheet) Sheet2(Second sheet) Sheet3(Third Sheet) The sheets have named lists and other references between sheets that must me maintained. I tried the 'Move or Copy..' but that maintained the Sheet* number. I tried to create a new workbook and cop the cells, but that lost all the Named list references. I'm doing this because I'm building a master template and want it 'clean' and in order. And I'm trying to avoid redoing all the lists, etc. Any other ideas? Thanks, John S. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't open embedded .msg objects in Excel. Help! | Excel Discussion (Misc queries) | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Unable to remove objects pasted into Excel from HTML grid | Excel Worksheet Functions | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |