fix worksheet view for all new worksheets
 

I wish to keep the view and scaling formats on all new worksheets I open in a
workbook. How do I do this.

fix worksheet view for all new worksheets
 

You can open a new workbook and delete all but one sheet. Customize as
you wish then FileSave AsFile TypeMS Excel Template(*.xlt)

Name it SHEET and store in your XLSTART folder. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

On Thu, 5 Apr 2007 18:36:01 -0700, whf wrote:

I wish to keep the view and scaling formats on all new worksheets I open in a
workbook. How do I do this.