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.