Lock cells for input if dat has passed

This could be adapted

Please Login or Register  to view this content.

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

Hi RoyUk
Thanks for prompt reply. So say If todays date was after date in cell A1 I wanted to lock entry to cells range C1 to HH250 I would try the code:

--------------------

Please Login or Register  to view this content.

I have tried above code but it doesnt seem to do anything. Apologies, I have no VBA experience!
Many Thanks
Kevin :-)

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here