Listbox and Sheet properties

D

Dirk Bock

Hi folks,

I've downloaded a rather big Excel-file, which uses several listboxes
to organize the input. There are no macros in the file.

The listboxes on one sheet do not work correctly. If I select an item
from the list, the cell reverts to the default value. Fiddling around
with the properties of the listbox and the sheet protection was
unsuccessfull.

If I copy a working listbox control from another sheet in the same
file to the sheet with the problems, is stops working as well. So it
should be a problem with the settings of the sheet, shouldn't it?

Any help or hints will be appreciated!

---Dirk
 
Top