disable cells DataValidation

[amrane]

Dear forum,

I would like to get your support to customize cells access as below
the user can modify the cells content, but he can't modify the edition condition table as its mentioned in the attached file,

I think we need some macro to do it!!

Thx in advance

Amran

[mana]

you can use the macro recorder.

[amrane]

dear mana

thx for your comment, but I want to lock the access to the validation windows for these cells only, of course the user can modify value within the per-defined condition,

the macro record is not useful for this detail, as I tried,

Br
Amrane,

[mana]

You need to unprotect the sheet.