Setting default formats for color and comments

Guest · Feb 20, 2004

How do I set my color palette as a default so that I don't have to keep changing it in each workbook. And I do set the default formats for Comment texts so that I don't have to keep changing it in each comment. Thanks.

Frank Kabel · Feb 20, 2004

Hi
for your comments question have a look at
http://www.contextures.com/xlcomments02.html#Default

For your color question the following site may help you
http://www.mvps.org/dmcritchie/excel/colors.htm

Setting default formats for color and comments

Guest

Frank Kabel