renaming back the sheet index of a worksheet while retaining its original name

[LFKim2018]

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

 

[LFKim2018]

Mr Fluff

btw, what does the following do? could it be detrimental to my work or computer (sorry for my ignorance)?

BUT for this to work you will have to goto > File > Options > Trust Center > Trust Center settings > Macro Settings > Select "Trust access to the VBA project object model"

Thank you for your time

 

[LFKim2018]

Mr Fluff

sorry I did not check the trust option box.
now it is working fine!

isn't there a way for VBA to make the setting then return it back to the default?

THANK YOU VERY VERY MUCH FOR YOUR TIME AND ASSISTANCE

 

[Fluff]

could it be detrimental to my work or computer (sorry for my ignorance)?

YES, it could! It enables macros to make changes to (and write) other macros.

 

[Fluff]

isn't there a way for VBA to make the setting then return it back to the default?

Not that I know of.

 

[LFKim2018]

Mr Fluff

THANK YOU VERY VERY MUCH FOR YOUR TIME AND ASSISTANCE

 

[Fluff]

You're welcome