D
Duncan UK
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
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