Unprotect Cells depending on Cell value

G

Guest

Hi,

I would like to know if I am able to protect and unprotect a range of cells
based on the date in another cell.
For example:
Cells N13:N22 are for a period between 21Aug and 23Aug and Cells N27:N37 are
for a period between 25 Aug and 27 Aug. Today's date would be in Cell A1.
I wish to be able to unprotect Cells N13:N22 when Cell A1's value is
equal/greater than to 21Aug and re-protect them on 24Aug.

Thanks in advance
 
G

Guest

Sirknightly,
Thanks for the assistance, I will modify my spreadsheet to be able to
incorporate something along the lines of your suggestion.
 

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

find last populated cell in range of cells 6
change the color of cell background based on a result 2
Protect or Unprotect Cell dependent on different cell 2
Allocate Value Across Monthly Periods 1
insert cell content and shift cells down 1
Linking cells on different sheets within a workbook. 1
how to count if a cell value falls between two numbers 4
Changing values in cell based on system date 2

Top