XLStart...

[Guest]

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.

 

[Bob Phillips]

Tools>Options>General, Sheets in New Workbook

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Thanks Bob, Hasn't it got any template too where we can modify it? somewhere
in setting folders?
--

Regards

Sri

Tools>Options>General, Sheets in New Workbook

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Dave Peterson]

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.

Thanks Bob, Hasn't it got any template too where we can modify it? somewhere
in setting folders?

 

[Bob Phillips]

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)

Thanks Bob, Hasn't it got any template too where we can modify it? somewhere
in setting folders?