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. |
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 |
All times are GMT +1. The time now is 11:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com