ReOrder Excel Objects.

D

DocBrown

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 are:

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.
 
J

Jon Peltier

Change the codenames of the sheets. This is the property "(Name)", as
opposed to "Name", in the VB Editor's Property pane.

- Jon
 
D

DocBrown

Perfect! Thanks!

John

Jon Peltier said:
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
_______
Click to expand...
 
Top