View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Reset sheet count

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

Dan wrote:

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