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

--
Message posted from http://www.ExcelForum.com