excel 2000
 

how can I "fix" comment box size? It changes ever time I close the worksheet!

excel 2000
 

I can confirm that that happens to me too (and I use excel 2000), but know of
no fix...

"Brian J. Tully" wrote:

how can I "fix" comment box size? It changes ever time I close the worksheet!

excel 2000
 

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.
wrote:

how can I "fix" comment box size? It changes ever time I close the worksheet!

excel 2000
 

"Eddie O" wrote:

I can confirm that that happens to me too (and I use excel 2000), but know of
no fix...

"Brian J. Tully" wrote:

how can I "fix" comment box size? It changes ever time I close the worksheet!

excel 2000
 

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

"Eddie O" wrote:

I can confirm that that happens to me too (and I use excel 2000), but know of
no fix...

"Brian J. Tully" wrote:

how can I "fix" comment box size? It changes ever time I close the worksheet!