Lock specific rows with a drop down box

[ecraw]

I have a spreadsheet with data entered in columns A thru N. Columns are locked except for F,G,K,M, and N which data must be entered manually. In column O, I have a drop down box with "closed" in it. I want to lock the rest of the row (so if row in row 9, for example it would lock F9,G9,K9,M9, and N9) once the word "closed" is inserted with the drop down box. Anyone know how I could do this? I am currently using a macro but it doesn't work unless the sheet is unlocked. Thanks in Advance.

Macro currently used:

Please Login or Register  to view this content.

[Kenneth Hobson]

Welcome to the forum!

Change the password to suit. Right click the sheet's tab, View Code, and paste. I normally put the Protection code in thisworkbook's Open event so code can do this sort of thing.

Please Login or Register  to view this content.

[ecraw]

Worked like a charm! Thank you so much.