I came across an article that prevent a worksheet from being deleted without using sheet protect. IN THE WORKSHEET BEFORE DELETE SUB> it copied & renamed the sheet - and after the orig sheet was deleted - it renamed back the orig name (nice trick)... but the sheet index is now different... my query is how to rename back the sheet index and still retain the worksheet name
example - original sheet index= sheet20; sheet name = "Entry Form"
assuming the workbook's last index = sheet32
after the process> the new sheet index will be sheet33 sheet name (still) = "Entry Form"
the sheet20 will be gone from the list
How could I change it back to sheet20>"Entry Form"
Many Thanks
example - original sheet index= sheet20; sheet name = "Entry Form"
assuming the workbook's last index = sheet32
after the process> the new sheet index will be sheet33 sheet name (still) = "Entry Form"
the sheet20 will be gone from the list
How could I change it back to sheet20>"Entry Form"
Many Thanks