Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comment Boxes
My comment boxes experience the following conditions:
1. they collapse and can't be read unless I re-size the box 2. they grow into much bigger than necesary for the text they contain 3. they appear many rows away from the cell with the red comment indicator When I edit a comment one or more of the above conditons apply. I make the necessary changes, but they don't stay. When I re-open the file, the above conditions are back. |
#2
|
|||
|
|||
Comment Boxes
Maybe you could use some code from Debra Dalgleish to reset the comments.
http://contextures.com/xlcomments03.html#Reset and http://contextures.com/xlcomments03.html#Resize If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm RWS wrote: My comment boxes experience the following conditions: 1. they collapse and can't be read unless I re-size the box 2. they grow into much bigger than necesary for the text they contain 3. they appear many rows away from the cell with the red comment indicator When I edit a comment one or more of the above conditons apply. I make the necessary changes, but they don't stay. When I re-open the file, the above conditions are back. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding scroll bar to comment boxes | Excel Discussion (Misc queries) | |||
Code to delete all comment boxes | Excel Discussion (Misc queries) | |||
Why oh why are my comment boxes changing shape? | New Users to Excel | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
Comment Boxes | Excel Worksheet Functions |