Marc76
01-27-2021, 12:51 AM
Hello,
I wrote a calendar for meeting-room reservations.
One sheet is for one month with all the rooms an schedules.
So in the top rows are the weekdays and the row below the date.
example:
Monday
23
In the first column are the names of the rooms and the schedules.
Example:
Room 1
0800-1000
1000-1200
As the workbook is saved on a server and can be used by more persons, I had now the problem that probabely someone deleted a reservation.
I'm looking now for a VBA that works on a protected sheet like this.
By changing the value of a cell: a comment isautomatically inserted with Name of user, date an time.
If its changed again, the comment ist edited with the new username, date and hour, without deleting the first.
It should not be possible to edit or delete the comments manually.
Do you think that this would be possible?
I'm using Office 2016
Thank you
I wrote a calendar for meeting-room reservations.
One sheet is for one month with all the rooms an schedules.
So in the top rows are the weekdays and the row below the date.
example:
Monday
23
In the first column are the names of the rooms and the schedules.
Example:
Room 1
0800-1000
1000-1200
As the workbook is saved on a server and can be used by more persons, I had now the problem that probabely someone deleted a reservation.
I'm looking now for a VBA that works on a protected sheet like this.
By changing the value of a cell: a comment isautomatically inserted with Name of user, date an time.
If its changed again, the comment ist edited with the new username, date and hour, without deleting the first.
It should not be possible to edit or delete the comments manually.
Do you think that this would be possible?
I'm using Office 2016
Thank you