ReOrder Excel Objects.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Change the codenames of the sheets. This is the property "(Name)", as
opposed to "Name", in the VB Editor's Property pane.

- Jon
 
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...
 
Back
Top