Renumber "Microsoft Excel Objects" SheetN (XXX) ...

[Joe HM]

Hello -

Is there any way to renumber the Microsoft Excel Objects other than
copying/pasting the sheets in the correct order to a new workbook? I
have an Excel file where sheets have been deleted and added quite a
bit and I would like them to be Sheet1 (XXX), Sheet2 (YYY), ... again.

I do not use this name to refer to it (I use the "XXX" instead) so it
will not compromise any of the macros.

Thanks,
Joachim

 

[Bill Renaud]

This is known as the "Code Name". Go into the VBA editor (Alt+F11),
select the Properties window (use View|Properties Window to turn it on
if it is not visible), then change the string on the top line where the
property listed in the left column is "(Name)". The name that you see on
the worksheet tab is the property "Name", and is listed about 8 rows
down.

If you are not using this "Code Name" in any of your macros, then you
normally don't need to ever change or worry about the "Code Name".

 

[Joe HM]

Hello -

Wow ... that was easy!

Thanks a lot!

Joe