Time-lock specific cells after data entry

Cross-posted at https://www.mrexcel.com/board/thread...entry.1203019/ --6SJ
and at "reddit.com" : Time-lock cells after data entry (AliGW)

Hello guys!

Can I lock some specific cells some time (let's say 30 minutes) after data entry in my worksheet and protect them with a password?
This is the worksheet I need to time-lock.
The cells to be locked are G4:M4, G5:M5, G6:M6, G7:M7, and so on. Once the user inserts the number of tickets, he should have 30 minutes to modify them; after that time, changes should not be allowed anymore.

Can you help me? Is this possible? Thanks

Administrative Note:

Welcome to the forum Claudia_A.

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 provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added the link because it's your first post.

Prego!

You can review our rules at your convenience.

Hi,

Maybe the following may give you a idea

In the worksheet Code goes

Please Login or Register  to view this content.

In a module goes

Please Login or Register  to view this content.

It seemed to do the trick, there may be bugs tho