Reset sheet count

[Guest]

Once I delete sheet 1 on a workbook, the next time I insert a new sheet it is
called sheet 2 even though sheet 1 does not exist anymore - true I can just
rename sheet 2 to be sheet 1. But, is there a way to reset the count so that
next time I open a sheet it will not bee sheet 999...

Many thanks
Dan

 

[Bob I]

You could insert a blank template already named "Sheet 1".

 

[Guest]

That did not solve he problem - I will need to reset the count.

 

[Bob I]

Any reason you may not use a macro to Add and rename the sheet?