Thank You all for the help..one more question..for now

  • Thread starter Thread starter Stan Lo
  • Start date Start date
S

Stan Lo

Hi All.

Thank you all very much for all your help and suggestion. My incident is
now in placed and all key staff are entering the appropriate info on a
daily basis.
I just have one more feature which I would like to add to this spreadsheet.
Is it possible to protect data that are seven days or older so they cannot
be altered anymore after the period expired while new data can still be
entered?

Thanking you all for your help.

SLO
 
Is it possible to protect data that are seven days or older so they cannot
be altered anymore after the period expired while new data can still be
entered?
Click to expand...

if (Date-DateCell.Value)>6 then
DateCell.Locked=True
end if

Remember idiotic Excel behaviour: to protect cells you need to set
Sheet protection (with empty password to activate cells protection
only)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Entry 2
Excel Excel 2010 take data from one spreadsheet to paste to another 1
Where are all you MVPs hanging out now??? Pls? 6
Macro for uploading data from other Excel files 5
THANK YOU! 1
Crunching for Covid-19 3
Page 1 is full with data...now what?? 1
Excel Help to copy information from one row at a time to another sheet 1

Back
Top