It looks like you didn't really save that file as a template. Make sure you
choose that option from the "Save As Type" box at the bottom of the File|SaveAs
dialog.
(and don't forget to clean up that other file (book.xlt.xls, that is).)
Michael QC wrote:
Hello Bob,
Thank you I now have all new worksheets with the new default colours.
However on opening Excel instead of the woorksheet name being Book1 (and no
path) it appears as
"My Documents\Application Data\Microsoft\Excel\XLSTART\Book.xlt.xls"
Michael Q
"Bob Phillips" wrote in message
...
Save a workbook with the custom palette in the XLStart directory as a
template, named Book.xlt.
--
HTH
Bob Phillips
"Michael QC" wrote in message
...
I am able to copy a custom set of colours from an existing worksheet to a
new one. However I would prefer to change the default colours in all
future
worksheets. I cannot find a "Normal" document as in MS Word. How can I do
this?
Michael Q
--
Dave Peterson
|