Anchoring a Comment to a Cell

[Guest]

I am using comments exclusively as notes for individual cells in Excel 2000:
1) I need to anchor each comment to its cell so it is in the same location
relative to the cell when I reedit it later. Currently, when I add or delete
rows or columns, the comments for cells below and to the right of the
addition/deletion are shifted away from the cell in edit mode (extremely
annoying). I changed the Format Comment Properties to "Move but don't size
with cells", this reduced the movement but didn't eliminate it, so comments
can still eventually show up miles away from the cell in edit mode after
several row/columns are added or deleted.
2) I need to size a comment box to fit a multi-line comment and have it
stay the same size that I chose. Currently adding or deleting rows changes
the size of the box and can shrink it down to nothing.
3) I would like to change Format Comment defaults (such as Properties) but
don't know how.

 

[Dave Peterson]

You had a couple of replies at your first post.

I am using comments exclusively as notes for individual cells in Excel 2000:
1) I need to anchor each comment to its cell so it is in the same location
relative to the cell when I reedit it later. Currently, when I add or delete
rows or columns, the comments for cells below and to the right of the
addition/deletion are shifted away from the cell in edit mode (extremely
annoying). I changed the Format Comment Properties to "Move but don't size
with cells", this reduced the movement but didn't eliminate it, so comments
can still eventually show up miles away from the cell in edit mode after
several row/columns are added or deleted.
2) I need to size a comment box to fit a multi-line comment and have it
stay the same size that I chose. Currently adding or deleting rows changes
the size of the box and can shrink it down to nothing.
3) I would like to change Format Comment defaults (such as Properties) but
don't know how.

 

[Debra Dalgleish]

For question 3, which you didn't include in your previous post, you can
change the default font size, but not the default font type.

To change the default font size (this will also change the settings
for tooltips in Excel and other programs):

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the
default font used in Excel's comments)
You can also set the font to Bold or italic, and select a colour

To insert a comment with a specific font, you can use a macro:
http://www.contextures.com/xlcomments03.html#Formatted

 

[Dave Peterson]

Oops.

For question 3, which you didn't include in your previous post, you can
change the default font size, but not the default font type.

To change the default font size (this will also change the settings
for tooltips in Excel and other programs):

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the
default font used in Excel's comments)
You can also set the font to Bold or italic, and select a colour

To insert a comment with a specific font, you can use a macro:
http://www.contextures.com/xlcomments03.html#Formatted

 

[Guest]

To: Debra Dalgleish and Dave Peterson,
Thanks for answering #3 on this second post here. I really wanted to change
the Object Positioning Property under Format Comment to default to "Move but
don't size with Cells". However, based on your reponses on my first post, it
sounds like this may not be possible. So I'll use your reposition and
resizing code explained in my first posting as a macro that I can use
periodically to correct the problem with moving comments.