ListBox keeps shrinking every time I re-open my workbook

[VBAguy22]

Hi
I have a listbox in one of my sheets, it keeps shrinking every time I reopen my workbook and I have to expand it manually. It's VB code generated (every time I load the workbook the values are being sent into the listbox). Any ideas how I can lock the size? I know how to do it in Access but in Excel it seems to be missing that property.

 

[SkipVought]

Hi,

Try setting the Object Positioning option in the Format COntrol to NOT RESIZE with the cell.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}