You can change a windows setting:
http://www.contextures.com/xlcomments02.html#Default
(from Debra Dalgleish's site)

MongoMan wrote:

How can I pre format all Excel cell comments to Tahoma, font size 12 Bold, in
all workbooks and worksheets and set it as my default

--

Dave Peterson