I have this situation: every working day I have a Google Sheet where me and my staff enter some data. I want at certain date and time my staff to be blocked from editing that Google Sheet, so only the owner will edit it after that date/time.

The date is the name of the Google Sheet.

Is this possible? And if yes, how?

1 Answer 1


You need a combination of Time-driven triggers and the protect()-method of the Class Range can be used.

Your can find the full answer in a similar question that has been posted at https://stackoverflow.com/questions/31625064/locking-cells-in-google-sheets-at-a-specific-time.

You can apply the same method for all cells instead of particular ones.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.