| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reset sheet count
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reset sheet count
That did not solve he problem - I will need to reset the count.
"Bob I" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reset sheet count
Any reason you may not use a macro to Add and rename the sheet?
Dan wrote: That did not solve he problem - I will need to reset the count. "Bob I" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum/Count/Max at bottom of sheet | Excel Discussion (Misc queries) | |||
| Count from another sheet | Excel Discussion (Misc queries) | |||
| Should I use COUNT IF? from one sheet to another | Excel Worksheet Functions | |||
| I want to count *'s that i have put in my sheet ? | Excel Worksheet Functions | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
