how can I "fix" comment box size? It changes ever time I close the worksheet!
B Brian J. Tully Dec 1, 2005 #1 how can I "fix" comment box size? It changes ever time I close the worksheet!
E Eddie O Dec 1, 2005 #2 I can confirm that that happens to me too (and I use excel 2000), but know of no fix...
G Gord Dibben Dec 1, 2005 #3 Brian Have a look at the macros on Debra Dalgleish's site for re-setting position and re-sizing Comments. http://www.contextures.on.ca/xlcomments03.html#Reset Gord Dibben Excel MVP On Thu, 1 Dec 2005 12:49:01 -0800, "Brian J. Tully" <Brian J.
Brian Have a look at the macros on Debra Dalgleish's site for re-setting position and re-sizing Comments. http://www.contextures.on.ca/xlcomments03.html#Reset Gord Dibben Excel MVP On Thu, 1 Dec 2005 12:49:01 -0800, "Brian J. Tully" <Brian J.
B Brian J. Tully Dec 5, 2005 #4 Eddie O said: I can confirm that that happens to me too (and I use excel 2000), but know of no fix... Click to expand...
Eddie O said: I can confirm that that happens to me too (and I use excel 2000), but know of no fix... Click to expand...
B Brian J. Tully Dec 5, 2005 #5 I found the answer by stumbling around my worksheet, if you open the drawing tool and edit the comment box by putting a shadow on the box WALA the box maintains it size when your close and reopen the worksheet
I found the answer by stumbling around my worksheet, if you open the drawing tool and edit the comment box by putting a shadow on the box WALA the box maintains it size when your close and reopen the worksheet