In the project explorer in the VBE, select the entry for the sheet.

make the properties window visible. Change the (name) property.

--
Regards,
Tom Ogilvy


"GaryMay" wrote:

How do I renumber (reindex) a sheet using VBA.

Example:
sheet20(name) to sheet1(name)