Locking certain cells on a particular date and time.

[BigMcBen]

Hi

I'm not sure if this should be in here, or formulas and functions, but I have a spreadsheet where colleagues can enter their forecasted figures for the following week but I want to lock these cells at 4pm on the Friday. There is a cell which has the W/E date in it so is there a way that I can have cells D3:D100 lock at 4pm on Friday before the W/E date (UK format dd/mm/yyyy) stated in cell K1? Thanks Excel Lock Cells.png

[amarjeet.it]

Yes, it's possible and this can be achieved by a piece of VBA code. If you are familiar with VBA then I can provide you solution.

[BigMcBen]

Hi Amarjeet. I have a basic understanding of VBA and would be happy to try and implement your code. The sheet is also password protected so I'll also need some code to unlock the sheet whilst the cells are being locked and then reinstate the sheet protection if that's possible. Thank you.

[k1dr0ck]

try,
this will check every hour

put the 2 sub inside a module

Please Login or Register  to view this content.

Please Login or Register  to view this content.

inside the workbook open

Please Login or Register  to view this content.

[k1dr0ck]

my mistake
Friday would be a 6 so

Please Login or Register  to view this content.

also fixed the no end with statement see post #4 again