View Single Post
  #10   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Fred,

Could you tell me how to save the protection format to be my
default in all my spreadsheets??


Open the template file Book.xlt which should reside in your XLStart
directory. (The location of this directory varies depending on OS / XL
version, Iif necessary, perform a Windows search for the directory.)
Make any changes (e.g. to font) that you want as workbook defaults.
Save (without changing the file name or location) and close the file.

As for the protection format, are you certain that you want / need this in
*all* future workbooks? One big drawback to doing this is that you will
loose the very useful functionality of conditional formatting for other
purposes.

If this conditional format arrangement is one that you would often (but not
always) like, proceed as above but save the template file as (say)
Book_CF.xlt.
If you adopt this approach, your default workbooks will remain unchanged,
but opening a new workbook (via File | New) will open a dialog box which
will offer you the choice of the two template files.

---
Regards,
Norman



"Fred Evans" wrote in message
...