"How can I reference all the comment boxes in my workbook and resize them

J

Jeff Etcell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comment Boxes Re-sizing 0
how to resize the comment in a cell 1
How do I modify Cell Comments from VBA? 2
How can i make the comment boxes in word stay in the middle? 1
how can i edit the positioning of the balloon comment in a word fi 1
Comments boxes resizing 3
How do I put a reference number in the margin in Word 1
Can I change the default font for a comment box in excel globally 2

Top