Anchoring a Comment to a Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geno - 14 Oct 2006 07:40 GMT

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.

Signature

Vaya con Dios
Geno

Reply to this Message

Dave Peterson - 14 Oct 2006 12:38 GMT

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
[quoted text clipped - 13 lines]
> Vaya con Dios
> Geno

Signature

Dave Peterson

Reply to this Message

Debra Dalgleish - 14 Oct 2006 14:03 GMT

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

> 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
[quoted text clipped - 10 lines]
> 3) I would like to change Format Comment defaults (such as Properties) but
> don't know how.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Dave Peterson - 14 Oct 2006 15:49 GMT

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.
[quoted text clipped - 32 lines]
> Contextures
> http://www.contextures.com/tiptech.html

Signature

Dave Peterson

Reply to this Message

Geno - 16 Oct 2006 18:19 GMT

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.

Signature

Vaya con Dios
Geno

> 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.
[quoted text clipped - 27 lines]
> > 3) I would like to change Format Comment defaults (such as Properties) but
> > don't know how.

Reply to this Message