Reset New Workbooks

  • Thread starter Thread starter crookie74
  • Start date Start date
C

crookie74

When you open Excel, the first workbook you get is "Book1". If you
were to close it and then open a new workbook, you would get "Book2".
Is there a way to reset this so that it defaults back to "Book1", if
there are no othe workbooks open?

Thanks in advance
 
hi
excel remembers how many new books it has created per session and numbers
them accordingly. closing and reopening excel(new session) is the only way i
know to reset.

Regards
FSt1
 
There is no way to reset Excel's internal counter.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

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

Calling open workbook from another workbook 8
Opening a new workbook via a macro 2
Change workbook name to a generic name 4
Copying formulas to other workbooks 5
Closing Workbook then Activating Other Wb with Userform showing? 1
Compare and Highlight 1
How to Refer to Another Excel Workbook 1
workbook error - please help 1

Back
Top