Reset Sheet name tracking number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to reset Excel sheet tracking count.

For example I do not have right now a sheet1, but if I had a sheet it will
be called sheet 34 (because I deleted many).
I know that I can rename the sheet - but that is not what I am after, I want
that next time that I insert a sheet it will be sheet 1 if sheet 1 does not
exist, or sheet 2 if sheet 1 does exist but sheet2 does not.
Thanks ,
Dan
 
When you close and open a workbook the new sheet index is reset. I know of no
other way to reset it.

Kevin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run two macros for two different sheets 11
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Progressive number in different sheets 7
Code works but goes into endless loop and crashes 1
clear all sheets code 4
Change event code Find .Activate does not activate Target.value 4
Array code only works on selected sheet 14
Resize to last entry in row and copy to sheet 1 3

Back
Top