See Debra Dalgleish's site for a macro.

http://www.contextures.com/xlcomments03.html#Format


Gord Dibben MS Excel MVP

On Tue, 3 Mar 2009 06:08:02 -0800, David Ashford <David
wrote:

I am using Excel 2007 and want to change the font and pitch of all comments
in one go rather than doing so one by one.