VBA Code to unlock cells on a protected sheet based on cell value in another worksheet

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!

Welcome to the forum!

I normally use the protection code in the ThisWorkbook object's Open event. Change ken to suite.

Right click sheet1's tab, View Code, and paste.

Please Login or Register  to view this content.

Hello Ken,
Many thanks for the reply. Just to clarify a couple of questions -
1. Should I post this code in the sheet 1 or sheet 2?
2. I assume Ken is the password, and I can change it to any other.

1.

Right click sheet1's tab, View Code, and paste.

2.

Change "ken" to suite.

Note: "ken" <> "Ken".

Hi Ken,

I tried the code you mentioned and got an error message -
Run time error '9':
Subscript out of range.

What should I do?

Hi Ken - No worries. I found a fix. The worksheet works perfect!! Thanks so much for your help with the code.