| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset Sheet name tracking number
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reset Sheet name tracking number
When you close and open a workbook the new sheet index is reset. I know of no
other way to reset it. Kevin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reset Sheet name tracking number
Many thanks, That solved my problem.
"Kevin Jones" wrote: When you close and open a workbook the new sheet index is reset. I know of no other way to reset it. Kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can not reset default number of copies to print. | Excel Discussion (Misc queries) | |||
| Reset sheet count | Excel Discussion (Misc queries) | |||
| Tracking Number of Changes | Excel Discussion (Misc queries) | |||
| Can the Autoshape number in the namebox be reset? | Excel Programming | |||
| Need to reset Check Box ID number | Excel Programming | |||
Linear Mode
