![]() |
XLStart...
Hi,
Excel always gives 3 sheets when we create a new workbook as per the default setting, But I want to modify the standard setting to alter the no of sheets to come!! I know it can be done using XLStart.... something, but don't remember the exact thing... Any help please. -- Regards Sri |
XLStart...
ToolsOptionsGeneral, Sheets in New Workbook
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sri" wrote in message ... Hi, Excel always gives 3 sheets when we create a new workbook as per the default setting, But I want to modify the standard setting to alter the no of sheets to come!! I know it can be done using XLStart.... something, but don't remember the exact thing... Any help please. -- Regards Sri |
XLStart...
Thanks Bob, Hasn't it got any template too where we can modify it? somewhere
in setting folders? -- Regards Sri "Bob Phillips" wrote: ToolsOptionsGeneral, Sheets in New Workbook -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sri" wrote in message ... Hi, Excel always gives 3 sheets when we create a new workbook as per the default setting, But I want to modify the standard setting to alter the no of sheets to come!! I know it can be done using XLStart.... something, but don't remember the exact thing... Any help please. -- Regards Sri |
XLStart...
I would think tools|Options|General tab|Sheets in new workbook would be the
easiest solution. But you can create a template file named book.xlt with the number of sheets you like (and anything else you want). Put it in your XLStart folder. Then excel will use that when you create a new workbook by clicking on the new icon on the standard toolbar. Sri wrote: Thanks Bob, Hasn't it got any template too where we can modify it? somewhere in setting folders? -- Regards Sri "Bob Phillips" wrote: ToolsOptionsGeneral, Sheets in New Workbook -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sri" wrote in message ... Hi, Excel always gives 3 sheets when we create a new workbook as per the default setting, But I want to modify the standard setting to alter the no of sheets to come!! I know it can be done using XLStart.... something, but don't remember the exact thing... Any help please. -- Regards Sri -- Dave Peterson |
XLStart...
Why would you need to if the options setting gets you what you want?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sri" wrote in message ... Thanks Bob, Hasn't it got any template too where we can modify it? somewhere in setting folders? -- Regards Sri "Bob Phillips" wrote: ToolsOptionsGeneral, Sheets in New Workbook -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Sri" wrote in message ... Hi, Excel always gives 3 sheets when we create a new workbook as per the default setting, But I want to modify the standard setting to alter the no of sheets to come!! I know it can be done using XLStart.... something, but don't remember the exact thing... Any help please. -- Regards Sri |
All times are GMT +1. The time now is 02:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com