Good afternoon;
I need the help of somebody.
I need one code to lock some especific range of cells depending of the value of other cell in the same row.
If the value of the cell X in the column F is null or empty, the ranges AGX:AIX; AKX:AMX; CDX:CFX; CHX:CJX is locked, if not is not unlocked.
The code used is:
But dont lock and unlock nothing.
Could somebody to help me?
Is it possible no to use "Worksheet_Change" in order that allways works without changing nothing in the worksheet?
Thanks in advance.
Bookmarks