Drop Down box resizing on open
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 |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com