Need help with locking sheet

Microsoft Excel 2003 (full product)
April 19, 2010 at 20:33:19
Specs: Windows XP

I would like to make my worksheet readonly after 12:00 AM of the day defined the range of cells. Say for example column A, stores a set of dates for every row, user should not be able to edit the data of that row if the data is reached.

Eg: if A6 is 20th April 2010, editing of E6 should be allowed only till 19th April and should be restricted or locked or freezed from 20th April 2010.


See More: Need help with locking sheet

Report •

April 19, 2010 at 22:55:53
jamie_dsouza, seems to me you should be able to write a script that'll do that. Sadly, I don't know how, but you'll likely get more and more knowledgeable responses in the programming forum @:
Ed in Texas.

Report •
Related Solutions

Ask Question