Lock row based on cell value in same row

Hello, wondering if you can help me. I'm very new to writing macros...

I've got a template spreadsheet, which will contain certain validation lists, formulas and conditional formats.
Data is then imported into columns A:E, and after that I'd then like to run a macro.
One of the things I'd like it to do is if cells in column E contain the word "Header", I'd like it to remove any existing validation lists in that row and lock the entire row for editing.
(there is no set amount of rows; this will differ each time).

How would I write this in VBA?

Your help is much appreciated

Regards, Eline

Please Login or Register  to view this content.

Thank you for getting back to me so quickly.

For some reason, the above VBA doesn't seem to be doing anything? Help?

You are going to have to be a bit more specific.

Uploading a workbook with the code in as you are using it would help.
-How are you triggering the code to run?
-Is header case sensitive?


I did double check and the code works if I put Header in E1 in a new workbook and run it, column E becomes locked.

Apologies for not being clear.
I am creating a seperate macro and am running it by going into Tools/Macro/Macros (for now).
It will always say Header (caps H).
If the cell in column E says Header, I would like the entire row of that cell to be locked (so not column E), if it says something else, I do not want this to be locked.

Hope this explains your questions? Thank you

I was aiming for something different, try this instead:

Please Login or Register  to view this content.

This is great, thank you; it now removes the validation lists from the cells if column E contains Heading. It hasn't locked the row though, am I missing a step?
(has this anything to do with locking and unlocking cells via Protecting the sheet?)

Your help is truly much appreciated, thank you

It will set the cell property locked to true, this is the same as right clicking the cell, clicking format, security and then locked check box. This doesn't actually "lock" the cell unless the sheet is protected.

Brilliant, this is exactly what I was after! Thank you so so much for your help, you're a star!