Home |
Search |
Today's Posts |
#1
|
|||
|
|||
comment boxes
I would like to change the default setting for comments. e.g. I want the
default setting to always be "move but don't size with cells" rather than "don't move ...". I can change it for an individual comment, but I cannot find a way to apply t to all comments. |
#2
|
|||
|
|||
I don't think you can change the default nor change existing comments easily
through the UI. Here's a macro that will do it however: Sub AllCommentsMoveNoSize() Dim shp As Shape For Each shp In ActiveSheet.Shapes If shp.Type = msoComment Then shp.Placement = xlMove End If Next End Sub -- Jim Rech Excel MVP "w-domo" wrote in message ... |I would like to change the default setting for comments. e.g. I want the | default setting to always be "move but don't size with cells" rather than | "don't move ...". I can change it for an individual comment, but I cannot | find a way to apply t to all comments. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I delete ALL text boxes in Excel worksheets? | Excel Discussion (Misc queries) | |||
Where to stick macro to change default comment font? | Excel Discussion (Misc queries) | |||
How do I set default comment font | Excel Discussion (Misc queries) | |||
HOW DO I PRINT THE ENTIRE COMMENT | Excel Discussion (Misc queries) | |||
Comment position..?? | Excel Discussion (Misc queries) |