filling a combobox (without being prompted to save the workbook EVERY time its opened

[neowok]

basically i am being prompted to save the workbook every single time it
opened and have narrowed it right down to the 'listfillrange' of
combobox that i have.

if i put anything into listfillrange then every time the workbook i
loaded, even if nothing is done other than click the close button, i a
prompted to save it due to changes.

there has to be a way around this surely? i just cant imagine ever
excel spreadsheet in the world that contains a vb combobox has t
prompt users to save the workbook every single time.

the information in the combobox is totally static and will never chang
so i dont need any kind of dynamic way of filling it, i just need t
get the values into the combobox without it doing this prompting al
the time, its rediculous

 

[BrianB]

Is this in a worksheet ?

If so, you could try the combo from the Forms toolbar

 

[neowok]

yup its on a worksheet. i cant use the forms one because the text in i
is miniscule and you cant change the font. the sheet has to be viewe
at 40% zoom because its quite big so i have to be able to alter th
font sizes etc so its visible