correct
1/ unlock all cells in sheet except cell with predefined list
2/ protect sheet
it works ok in this way, except that items of list are enabled (shown in normal black font color rather than disabled in grey)
but this is minor reason for not using this technique
many thanx
|