View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Default font/Size in Comments Box

You could use a macro like the one from Debra Dalgleish's site:
http://www.contextures.com/xlcomments03.html#Plain



Paul Calcagno wrote:

I'm running MS Office 2007 on a Vista Home Premium OS SP2, all WU's current,
with 2 GB of RAM. Windows defender, Spyware Doctor, MBAM, SAS. Everything's
running just fine.

I'd like to know if there's an easy way to format my Comments boxes (right
click and select `insert comment') so that the default is not bold text with
a font size of 9. I'd like to be able to set the default font to something
else and the default font size to Arial. Is this possible for a hack like
me?

Thanks in advance...........Paul C.


--

Dave Peterson