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.
|