Hi, I have a use case to lock cells with data in a Google sheet. My intention is to use this logic in a time trigger to automatically lock cells with data at the end of the day. This will allow users to enter values into any blank cell and correct it, if needed, before it is locked at the end of the day. Any help will be appreciated.
Without a lot more detail, AND a sample file that is represenative of the real life file, we can only guess if your project is simple, or monumental.
I suggest you try doing a lot more research into what you are wanting to achieve, then come back when you have enough information for us to help you with any problems.
Start with these groups:
https://groups.google.com/g/google-a...ript-community
https://stackoverflow.com/questions/...le-apps-script
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Hi, Thanks for your reply. Here is the link to a sample Google sheet.
I just need to be able to lock all cells which are not blank at the end of the day. The data could be anywhere on the sheet. Please let me know if I can clarify anything further. Appreciate your time.
https://docs.google.com/spreadsheets...it?usp=sharing
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks