Thread: new books
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default new books

Not that I am aware of.

--
Regards,
Tom Ogilvy


"whylite" wrote:

I was wondering if there is any way to reset the new book count in excel with
a macro. Currently I have a macro that creates a new book, adds data to it,
and then saves it with a new name. What I have noticed is that if I run the
macro a few times the new book comes up as book1, book2, book3. Is there any
way a macro could reset the counter so that every time Book1 comes up.
--
Thanks!
Shane W