Lock cell(s) after data input using macro.

[kawaitang]

Hello everyone,

Currently I am working on a excel sheet with macro's. If I choose 'NL' in D8 I want H8:J8 locked and if it is other than 'NL' H8:J8 will be unlocked.
I am using the following code:

Please Login or Register  to view this content.

I don't know what i did wrong but somehow it gives me a error 13 message that makes the following sentence yellow: If Target <> Range("D8") Then Exit Sub

Is it possible to make the range D8:D200?
Also, I want this code to be working for the whole workbook instead of worksheet.

Could anyone help me with this code?

[TMS]

Maybe this will work for you:

Please Login or Register  to view this content.

Regards, TMS

[Winon]

Hello kawaitang,

Welcome to the Forum.

What TMS gave you should do the job, or you could also try:

Please Login or Register  to view this content.

[kawaitang]

Thanks TMShucks and Winon! It works fantastic!

[TMS]

You're welcome.

[Winon]

Glad we could help.