Adapt an automated advanced filter code to lock a particular column?

Yesterday I posted a question about automating an advanced filter and got a really helpful response from jaslake, thread here: http://www.excelforum.com/excel-prog...lp-needed.html

What I would now like to do, however, is one of the following:

1. Either lock and/or hide column L on the individual "Area" sheets that result from running the filter, so that an item can only be marked as complete on the "Master Timetable" sheet.

OR

2. Create some kind of dynamic link, so that if a user marks an item as complete (after running the update) on one of the "Area" sheets, it also updates the item on the Master Timetable, and does not lose the info the next time the update is run.

I'm not sure which of the two options is the easiest, to be honest.

The code that jaslake produced for me is as follows:

Please Login or Register  to view this content.

And my workbook is attached below. Thank you in advance for any help, it would be much appreciated!

H Edie0512

Just add these two lines of code

Please Login or Register  to view this content.

I've opted for the "Hide" solution...the cells could most certainly be locked if you choose. However, that also involves protecting the "Areas" worksheets. If you prefer that route let me know.