S
sashton
I have a worksheet that I've enabled "track changes" on.
It's a pretty large worksheet. It was fine at first. Now
when I attempt to show the comments, the connecting lines
take me way across the sheet, requiring me to scroll
sideways to find the comment box, then the box is squashed
and needs to be resized to be read. This sheet acquires
quite a few comments in a day. I found a visual
basic "fix" for this "feature" in the help on the web
pages, but I have no background with VB so I'm not sure
where to put this script. Is there somewhere I can just
copy and paste this to in order to make a macro out of it?
Unless someone knows of a better solution.
It's a pretty large worksheet. It was fine at first. Now
when I attempt to show the comments, the connecting lines
take me way across the sheet, requiring me to scroll
sideways to find the comment box, then the box is squashed
and needs to be resized to be read. This sheet acquires
quite a few comments in a day. I found a visual
basic "fix" for this "feature" in the help on the web
pages, but I have no background with VB so I'm not sure
where to put this script. Is there somewhere I can just
copy and paste this to in order to make a macro out of it?
Unless someone knows of a better solution.