Hi all, sorry that I'm jumping straight into a questions that requires your assistance, but I am very desperate so I'm hoping someone could assist me with this. I'd really appreciate it as I've been struggling with finding a solution for a while now on the internet.
I created a macro-enabled workbook which is a basically a performance appraisal system for employees.
I placed the workbook in SharePoint, in a location accessible by all 38 employees.
I have given Edit permissions to all employees.
Here's the issue with an example:
Pauline
When Pauline opens the workbook, she enters her username and password and she is then only able to view her sheet. (I used VBA code and this works).
Pauline continues and is busy making changes on her sheet.
Devan
While Pauline is doing that, Devan (another employee) opens the same workbook and logs in with his username/password, and then while the workbook is taking him to his sheet using the VBA code, Pauline's sheet goes white and then as soon as Devan is logged in and can see his sheet, Pauline then only sees Devan's sheet on her computer.
This is not what I want to happen. I want Pauline to continue seeing only her sheet and Devan to see only his sheet while working on the same workbook, and logged in as different users.
Any tips on how to achieve this, please?
I am hoping this is possible and a sort of easy fix somehow
I created a macro-enabled workbook which is a basically a performance appraisal system for employees.
I placed the workbook in SharePoint, in a location accessible by all 38 employees.
I have given Edit permissions to all employees.
Here's the issue with an example:
Pauline
When Pauline opens the workbook, she enters her username and password and she is then only able to view her sheet. (I used VBA code and this works).
Pauline continues and is busy making changes on her sheet.
Devan
While Pauline is doing that, Devan (another employee) opens the same workbook and logs in with his username/password, and then while the workbook is taking him to his sheet using the VBA code, Pauline's sheet goes white and then as soon as Devan is logged in and can see his sheet, Pauline then only sees Devan's sheet on her computer.
This is not what I want to happen. I want Pauline to continue seeing only her sheet and Devan to see only his sheet while working on the same workbook, and logged in as different users.
Any tips on how to achieve this, please?
I am hoping this is possible and a sort of easy fix somehow