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 Default number of worksheets

Nitin,

Go to the Tools menu, choose Options, then the General tab. There, change
the "Sheets in new workbook" setting to 1.


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



"Nitin" wrote in message
...
When i open a excel file I want it should have only one
WorkSheet by default ....how can i do that ?

Nitin