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.

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.

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.