Hi,

I am building a spreadsheet that will be used by other people so am adding lots of comments boxes in to make it easier for people to use. However I am finding that many of the comments boxes keep changing size and often become so small that I can't read hardly any of the text in them at all! I cannot trace exactly why this is happening but seems to have something to do with me either moving cells around (drag and drop) or resizing rows and columns. What I want though is the comments boxes to stay exactly the same size as I have set them, regardless of where I move them too or how many changes I make to cell heights/widths etc!

Thanks in advance for any help.

Regards
Rob

Ps - I am using Excel 2007.