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) |