Default format of cell comments

[Al]

When I create a comment against a cell, it seems that the default formatting
is “Don’t move or size with cells.†This causes many problems when I hide
columns, so I need to change this to “Move but don’t size with cells.â€

Cannot seem to find how to change the "default." Can anyone help?

Using Office Professional Editoin 2003

 

[Dave Peterson]

I don't think you can change any of those defaults.

But you could have a macro that changes the setting after the fact.

Debra Dalgleish has tons of sample code:
http://contextures.com/xlcomments03.html

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

 

[Squeaky]

Hi Al,

What do you mean by "When I create a comment against a cell"?

Squeaky.

 

[Al]

"Insert - Comment" to produce a text box.

Hi Al,

What do you mean by "When I create a comment against a cell"?

Squeaky.

 

[Al]

Thank you for these links. I will be reading them with interest!