If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default format of cell comments
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 |
#2
|
|||
|
|||
Default format of cell comments
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 |
#3
|
|||
|
|||
Default format of cell comments
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 “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 |
#4
|
|||
|
|||
Default format of cell comments
"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 “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 |
#5
|
|||
|
|||
Default format of cell comments
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 . |
Thread Tools | |
Display Modes | |
|
|