View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

This is not a global option.

Must be done on each workbook.

One way around this is to open a new workbook then save as a Template with the
options you want.

Name the workbook BOOK and save as MS Excel Template(*.xlt)

Do not enter the extension, Excel will do that for you.

Store in your XLSTART folder and it will become the template for all workbooks
when opened via FileNew

Note: this will not affect previously saved workbooks.


Gord Dibben Excel MVP

On Thu, 14 Apr 2005 14:11:01 -0700, "flyaj"
wrote:

How do I set Read-Only Recommended as default to save files in Excel 2002?

Thanks.