 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Ancohoring a Comment to a Cell
I am using comments exclusively as notes for individual cells in Excel 2000: 1) I need to anchor each comment to its cell so it is in the same location relative to the cell when I reedit it later. Currently, when I add or delete rows or columns, the comments for cells below and to the right of the addition/deletion are shifted away from the cell in edit mode (extremely annoying). I changed the Format Comment Properties to "Move but don't size with cells", this reduced the movement but didn't eliminate it, so comments still show up miles away from the cell in edit mode. 2) I need to size a comment box to fit a multiline comment and have it stay the same size that I choose. Currently adding or deleting rows changes the size of the box and can shrink it down to nothing.  SignatureVaya con Dios Geno I don't know of a reliable way to prevent the comments from moving or changing size. However, you could run the code shown here, to resize the comments when required: http://www.contextures.com/xlcomments03.html#Resize > I am using comments exclusively as notes for individual cells in Excel 2000: > 1) I need to anchor each comment to its cell so it is in the same location [quoted text clipped - 7 lines] > the same size that I choose. Currently adding or deleting rows changes the > size of the box and can shrink it down to nothing. SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Debra, Thanks for the comment repositioning and resizing macros. I'll incorporate them into my worksheet. I have a lot of comments, and several rows and columns that are hidden. I'll have to experiment with how effective the macros will be for my circumstances. First, I'll have to learn about macros. Dave McRitchie's tutorial at http://www.mvps.org/dmcritchie/excel/getstarted.htm sounds like a good starting point. Thanks again. SignatureVaya con Dios Geno > I don't know of a reliable way to prevent the comments from moving or > changing size. However, you could run the code shown here, to resize the [quoted text clipped - 13 lines] > > the same size that I choose. Currently adding or deleting rows changes the > > size of the box and can shrink it down to nothing. For your second problem see: http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/ thread/82a92db0020ecac3/523ebf077ff88968?lnk=st&q=%22gary%27%27s+student%22+exce l+comment&rnum=3&hl=en#523ebf077ff88968 SignatureGary's Student > I am using comments exclusively as notes for individual cells in Excel 2000: > 1) I need to anchor each comment to its cell so it is in the same location [quoted text clipped - 7 lines] > the same size that I choose. Currently adding or deleting rows changes the > size of the box and can shrink it down to nothing. Thanks for the response. It provides a corrective action similar to Debra D's which I will implement. It's nice to know that I am not the only one suffering from comment problems. It would be nice if MS just anchored the comments and kept the size fixed. SignatureVaya con Dios Geno > For your second problem see: > [quoted text clipped - 11 lines] > > the same size that I choose. Currently adding or deleting rows changes the > > size of the box and can shrink it down to nothing. Thanks for responses to this and second posting. First posting failed with a message to reenter, ergo the second, more expanded posting (with three parts rather than two). Please respond only to the other three part posting. I will transfer all to it. Thank you. SignatureVaya con Dios Geno > I am using comments exclusively as notes for individual cells in Excel 2000: > 1) I need to anchor each comment to its cell so it is in the same location [quoted text clipped - 7 lines] > the same size that I choose. Currently adding or deleting rows changes the > size of the box and can shrink it down to nothing. I am closing this dialogue and leaving the answers to #1 and #2 here. The answer to #3 is found in the second posting. Thanks for all of the help. SignatureVaya con Dios Geno > Thanks for responses to this and second posting. First posting failed with a > message to reenter, ergo the second, more expanded posting (with three parts [quoted text clipped - 12 lines] > > the same size that I choose. Currently adding or deleting rows changes the > > size of the box and can shrink it down to nothing. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.