Hi,

Needless to say, I am new to excel VBA and grappling with a problem. I have referred a lot of posts on similar topics, but none seem to help in my case. This is what I have -

I have 2 worksheets - Sheet 1 and Sheet 2. Sheet 2 is protected. What I want to do is,If value in Sheet 1, cell C20 is 0 (or blank), then I want to unlock range G10:P13 in sheet 2. If however, user enters a value in sheet 1 cell C20, then I want to keep sheet 2 range G10:P13 locked (i.e. entire sheet 2 locked)

Would appreciate your help!