can you control how comments print in excel xp or 2003?

[Szkrad]

I noticed a user at the copier today, using the blow up function to
try to enlarge the comments that he had printed out at the end of his
excel worksheet. He commented that he could not change the font for
the comments. I went back to my desk, and was able to replicate the
issue...

In short, you can format comments for on-screen viewing (and
presumably when you print comments "in place"), but if you print out
all the comments at the end of your document, you apparently can't
control the font/size/formatting/etc. The only thing I could find that
made a different to how it printed was the "page zoom" or "fit to X by
Y pages", but that makes the rest of the worksheet print out wrong.

Any ideas? Is this a known issue, and/or by design?

My computer is Win2k w/ Office XP, the user is running WinXP & Office
2003. Same thing on both machines and various printers.

Thanks,
Szkrad

 

[Gord Dibben]

You cannot control the default FontType, which is Tahoma, with using VBA
code.

You can change the fonttype, size and formatting manually by Edit Comment.

You can re-size the Comments by simply dragging on the edge.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

I should mention that you can change the Comment default font size through
Windows Display>Appearance>Advanced>Item

Re-size the Tooltips font. This will affect all Tooltips.


Gord

 

[Szkrad]

Gord,

Thank you for the quick response. The methods below change how the
comments show on screen and when you select the option "as displayed
on sheet" on the sheet tab in page setup; however, if you select
instead "at end of sheet" the edits made in this manner to the
comments do not seem to affect the printed out comments that follow
the worksheet printout.

Brian

 

[Gord Dibben]

I see now what you're getting at.

I don't know how to overcome that without dragging the Comments to bottom of
sheet and set to "As displayed on sheet".

But that looks a litlle mesy what with the connection arrows visible.

I s'pose some code could be devised to copy the Comment Text into shapes
like rectangles and place the rectangles across the bottom but a lot of
work.


Gord

 

[Gord Dibben]

One more suggestion.

Use the code provided by Debra Dalgleish to list all the Comments on a
separate sheet.

You could format as you like.

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


Gord