Hi, I am trying to create an excel sheet, based on values from A2,B2 and C2 the cells A5, A7, should lock
List box option N;M;H;SH
A2, B2, C2 = N then lock a4, a5, a6, a7
A2,B2,C2= M then lock A10
A2,B2,C2= H then lock A11
A2,B2,C2= SH then lock A20
Hi, I am trying to create an excel sheet, based on values from A2,B2 and C2 the cells A5, A7, should lock
List box option N;M;H;SH
A2, B2, C2 = N then lock a4, a5, a6, a7
A2,B2,C2= M then lock A10
A2,B2,C2= H then lock A11
A2,B2,C2= SH then lock A20
You can try this code, placed in your Sheet Module
It works under the following options ( as far as I understood your post):
if A2= B2= C2 = N then lock a4, a5, a6, a7
if A2=B2=C2= M then lock A10
if A2=B2=C2= H then lock A11
if A2=B2=C2= SH then lock A20
in any different case, everything is unlocked.
Please Login or Register to view this content.
Last edited by vichopalacios; 09-08-2017 at 05:08 PM.
Barriers are there for those who don't want to dream
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks