Comments Defaults

  • Thread starter Thread starter shaz
  • Start date Start date
S

shaz

Hello i want to change the shape and font of Comments in Excel 2003 and then
apply this as the default to all Comments created thereafter. I thought I
just needed to right click on the comment and select Set Autoshape Defaults
but this does not work.
 
Very little you can do with Comments format that does not involve the use of
VBA.

You can change font size but not font type(Tahoma) through your Windows
Appearance settings for Tooltips.

See Debra Dalgleish's site for VBA on Comments.

http://www.contextures.on.ca/xlcomments03.html


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change shapes for Cell Comments 3
Change default font for Comments 3
Default font/Size in Comments Box 3
Default Comment Font 2
comment format 2
Excel, how do I set up default comment containing picture? 10
How can I set the show/hide default for comments in Excel? 1
How do I change the comment default format to include date? 4

Back
Top