Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"How can I reference all the comment boxes in my workbook and resize them
Hi, I have a problem in a file where I was using the Auto-
Filter and adding comments into the cells. Sometime during the day a problem arose whereas the Comment boxes (over 500)collapsed to virtually nothing and had to be-sized so as to view the comment. I can resize these individually but not GLOBALLY. My predicament is that every comment boxed collapsed GLOBALLY so why can't I re-size them myself GLOBALLY? In case you would like a copy of my file so you can investigate the problem. Also some of the boxes were nowhere near the cell when I came to edit them and it may have been at row 187 for instance but the comment box was at row 5486, why did it go for a trip? I went to a backup to restore but just for future reference I would like to know what happened. I still have this file if anyone is interested in working on this confounded problem I have, I will be more then happy to email it to you. Please help me with this. Jeff Etcell Australia Ta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"How can I reference all the comment boxes in my workbook and resize them
Jeff,
I'm not sure that I read you correctly, but here's a link that might address your conundrum (from Debra Dalgleish). http://www.contextures.com/xlcomments03.html#Reset HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- Hi, I have a problem in a file where I was using the Auto- Filter and adding comments into the cells. Sometime during the day a problem arose whereas the Comment boxes (over 500)collapsed to virtually nothing and had to be-sized so as to view the comment. I can resize these individually but not GLOBALLY. My predicament is that every comment boxed collapsed GLOBALLY so why can't I re-size them myself GLOBALLY? In case you would like a copy of my file so you can investigate the problem. Also some of the boxes were nowhere near the cell when I came to edit them and it may have been at row 187 for instance but the comment box was at row 5486, why did it go for a trip? I went to a backup to restore but just for future reference I would like to know what happened. I still have this file if anyone is interested in working on this confounded problem I have, I will be more then happy to email it to you. Please help me with this. Jeff Etcell Australia Ta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add comment and resize it | Excel Discussion (Misc queries) | |||
What would cause the comment box to resize and move on it's own? | Excel Worksheet Functions | |||
Comment boxes are shrinking and "disappearing" | Excel Worksheet Functions | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
How to resize a comment box, by embedding code into a function? | Excel Worksheet Functions |