Forum Discussion

Rash320's avatar
Rash320
Copper Contributor
Aug 13, 2022

Date Picker

How can I make a date picker work while some excel cells are not locked, the sheet is protected? I would like it to work in those unlocked cells 

 

Thanks 

 

Rash 

 

 

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Rash320 

    Lock or unlock specific areas or Cells of a protected worksheet

    By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.

     

    Detailed information can be found in the link above

     

    Hope I was able to help you with this information.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources