Default number of worksheets

  • Thread starter Thread starter Nitin
  • Start date Start date
N

Nitin

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

Nitin
 
Nitin,

Go to the Tools menu, choose Options, then the General tab. There, change
the "Sheets in new workbook" setting to 1.
 
You must log in or register to reply here.

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

Open Specific Worksheet Using Button Form Control in Excel 0
To protect user's privacy 1
Opening excel worksheet using excel 2003? 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to call module function or sub from the Add In? 3
Customize Quick Access Toolbar 5
How to force macros refer to ActiveWorkbook 2
Insert value in text box based on previous tselected value. 2

Back
Top