have an Excel 2007 file with multiple dropdown lists based on named ranges
some of these lists are free available for any choice by all users
other lists are predefined on 1 value and should NOT be available for changing
How can I block this selection in such a way that users can see the whole list but cannot change the selection (e.g. all values, except the selected item, in enabled values ) ?
thanx
regards