View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Reset New Workbooks

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)

On Sat, 17 Jan 2009 09:16:29 -0800 (PST), wrote:

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