I have created a booking system for some IT suites and want to let other users book a room and then stop anyone overwriting it unless they contact me if they have made a mistake so I can then unlock it again. Is this possible? I know how to lock/ unlock cells and protect them but is there any code so I can do this?
The process would be
1) User Finds room available (blank cell) so they can type in it
2) Book room by user typing into cell their intials
3) Pop up message comes up asking for confirmation of booking
4) cell locks so no one else can overwrite booking (unless admin does it)
Thanks in advance!
The process would be
1) User Finds room available (blank cell) so they can type in it
2) Book room by user typing into cell their intials
3) Pop up message comes up asking for confirmation of booking
4) cell locks so no one else can overwrite booking (unless admin does it)
Thanks in advance!