When I create a comment against a cell, it seems that the default formatting
is €œDont move or size with cells.€� This causes many problems when I hide
columns, so I need to change this to €œMove but dont size with cells.€�

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

Using Office Professional Editoin 2003

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 he
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.)

Al wrote:

When I create a comment against a cell, it seems that the default formatting
is €œDont move or size with cells.€� This causes many problems when I hide
columns, so I need to change this to €œMove but dont size with cells.€�

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

Using Office Professional Editoin 2003

--

Dave Peterson

Hi Al,

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

Squeaky.

"Al" wrote:

When I create a comment against a cell, it seems that the default formatting
is €œDont move or size with cells.€� This causes many problems when I hide
columns, so I need to change this to €œMove but dont size with cells.€�

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

Using Office Professional Editoin 2003

"Insert - Comment" to produce a text box.
"Squeaky" wrote:

Hi Al,

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

Squeaky.

"Al" wrote:

When I create a comment against a cell, it seems that the default formatting
is €œDont move or size with cells.€� This causes many problems when I hide
columns, so I need to change this to €œMove but dont size with cells.€�

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

Using Office Professional Editoin 2003

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

"Dave Peterson" wrote:

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 he
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.)

Al wrote:

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
.