|
| 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
November 10th, 2009, 04:02 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
November 10th, 2009, 01:12 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
November 10th, 2009, 04:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
November 11th, 2009, 08:00 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
November 11th, 2009, 08:03 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
