Hi ,
I have an excel file which is used by multiple users at a time. The excel file is uploaded in sharepoint. The problem with the file is the data entry sometimes goes wrong due to overwriting issue. Hence, I want to Lock the cells based on application.username code. All the user name will be available in the workbook. So, a macro can be created that if application username is same as the name in the sheet than unlock that particular row. My question is if multiple user work together in that excel file then can they edit the unlock cells of other user.
I have an excel file which is used by multiple users at a time. The excel file is uploaded in sharepoint. The problem with the file is the data entry sometimes goes wrong due to overwriting issue. Hence, I want to Lock the cells based on application.username code. All the user name will be available in the workbook. So, a macro can be created that if application username is same as the name in the sheet than unlock that particular row. My question is if multiple user work together in that excel file then can they edit the unlock cells of other user.