| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Default number of worksheets
When i open a excel file I want it should have only one
WorkSheet by default ....how can i do that ? Nitin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Default number of worksheets
Nitin
ToolsoptionsgeneralSheets in new workbook=1 -- HTH Nick Hodge Southampton, England "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Cell format of existing Worksheets got changed automatical | Excel Discussion (Misc queries) | |||
| Setting and Locking the default language for Excel Worksheets? | Excel Worksheet Functions | |||
| can you set a default header and footer for ALL worksheets? | Setting up and Configuration of Excel | |||
| Default # of worksheets | Excel Discussion (Misc queries) | |||
| Default # of worksheets | Setting up and Configuration of Excel | |||
![Nitin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
