Thread: # of sheets in a new workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default # of sheets in a new workbook
JT,

Try something like

Application.SheetsInNewWorkbook = 4


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"JT" wrote in message
...
When you programmatically add a new workbook, is it possible to
indicate the
number of sheets the new workbook should have?

Thanks for the help.......
--
JT


Reply With QuoteReply With Quote