Lock Cells At Midnight

**gandolff** · 01-27-2009, 11:00 PM

OK, let me put it this way:

WHEN ATTEMPTING TO EDIT A CELL IN COL. A (say, A30), "LOCK THIS CELL" IF THE DATE IN THE CORRESPONDING CELL OF COL. D (D30) IS <TODAY(). BUT "ALLOW" IF THIS CELL (OF COL. D) IS >TODAY().

That's really all I'm looking for here...

Thanx,
Jeff

**Richard Buttrey** · 01-28-2009, 06:13 AM

Hi Jeff,

I don't experience the problem you outline. I have both advanced my PC date to check this, and also, but independently advanced the date in column D to > today. In both cases the macro works as you require.

Are you sure you have created this in the Worksheet_Change event?
If so, can you upload your version of the workbook so we can take a look?

Rgds

**gandolff** · 01-28-2009, 11:24 AM

OK, I'll get back to you tonight, after work...

Tanx again,
Jeff

**gandolff** · 01-29-2009, 11:51 PM

Hi,

I scrapped that WS I was working on. But the bottom line is that, when I pasted that above code into any 2003/XP Wks, all I get is a pop up message, but no locking of cells. I can still edit/delete at will.