I'm using Excel 2000 and have created a workbook with lots of drop down boxes
which keep resizing when I open up the sheet.

I have the drop downs in column B, with linked cells in column A with IF's
in column D based on column's A values.
I have macro's running in the background autofitting column D (the IF
variables can give results which range from 1-10 lines taken from another
sheet).
The drop down boxes have been positioned in the lower half of the cells so
the cell contents can be read.

I have made sure that each drop down box has 'move but dont size with cells'
selected but quite often when I load up the sheet some of the drop down boxes
re-format to .11cm's high (they are normally .56) and at the top of the cell
so it obscures the writing.

Any help or advice welcome