You can use code to make the column temporarily wider. There's sample
code he
http://www.contextures.com/xlDataVal08.html#Wider
Adam wrote:
I have a bunch of validation comboboxes on this excel spreadsheet. Because I
have the columns so small, it will not show the full length. Is there a way
for it to automatically expand?
Or is there a way to get the cells in a freeze frame to not be affected by
the resize of a column although it's in the same column?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html