PDA

View Full Version : disable cells DataValidation



amrane
01-27-2017, 09:58 AM
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
01-27-2017, 07:29 PM
you can use the macro recorder.

amrane
01-28-2017, 01:44 AM
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,:dunno

Br
Amrane,

mana
01-28-2017, 02:36 AM
You need to unprotect the sheet.