Reset New Workbooks

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
 
F

FSt1

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
 
C

Chip Pearson

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
Change workbook name to a generic name 4
VBA to open a shortcut to a workbook 3
Compare and Highlight 1
How to Copy a VB Module 7
Macro needed 3
help with a basic code? 0
workbook error - please help 1

Top