This was posted by Debra Dalgleish to change the default font color. But if you
do the same thing using your colours, it should work ok.
=====
This should set the default colour for any new books:
1. Create a new, blank workbook.
2. Choose ToolsOptions
3. On the Colour tab, click on the yellow square
4. Click Modify, select a colour as the default, click OK
5. To make yellow available, select the square that has the same colour
as the new default, and change it to yellow
6. Click OK.
7. Choose FileSave As
8. Save as Type: Template
9. FileName: Book
10. Location -- save the file in your XLSTART folder
11. Click Save
Brian Parsons wrote:
The default fill colour is yellow, I want to change this
to red rather than button down and select red each time I
use fill colour.
--
Dave Peterson