Hello fellow Excel Users,

I am not to automating tasks in Excel and would like your support with the following : 

Description: I have am excel spreadsheet and I am sharing through a sharepoint link with 10 users (inside and outside the organization). The spreadsheet has the majority of cells protected except for a selection of cells that are not and where the users can enter their records.

Objective: I want to have the record entered by a users to be locked once the file is saved and closed by this user. I want the following user not to be able to modify what the initial user entered.

Attempt: I have attempted the following code but it doesn’t meet the need as the cell is automatically locked once a value is entered. I want to give the user the possibility to modify the cells until they save a close the file.

I appreciate any orientation to solve this.

Cheers

​Hello fellow Excel Users, I am not to automating tasks in Excel and would like your support with the following :  Description: I have am excel spreadsheet and I am sharing through a sharepoint link with 10 users (inside and outside the organization). The spreadsheet has the majority of cells protected except for a selection of cells that are not and where the users can enter their records. Objective: I want to have the record entered by a users to be locked once the file is saved and closed by this user. I want the following user not to be able to modify what the initial user entered. Attempt: I have attempted the following code but it doesn’t meet the need as the cell is automatically locked once a value is entered. I want to give the user the possibility to modify the cells until they save a close the file. I appreciate any orientation to solve this. Cheers   Read More

​