View Single Post
  #3   Report Post  
Elijah
 
Posts: n/a
Default How to change the default Border, Font Color, and Cell Color

Thanks Bob, but no it did not work. It does not appear that these
settings are saved anywhere in a .xls or .xlt file.

I have made the changes and saved as an xlt to both the templates, and
xlstart directories in my profile. I have also made the change to
personal.xls and saved it, however it does not retain the settings.

It appears this setting is saved somewhere other than in any given file
(i.e the registry or somewhere else).

Thanks again Bob.

Anyone else have any input as this is still an open question?

Bob Phillips wrote:
I haven't tried this, but have you tried setting them in an empty workbook,
then saving that workbook as a template named Book.xlt, and save it in the
XLStart directory?