Macro-enabled workbook - Issue with co-authoring/sharing via user level access

Lugen

New Member
Joined
Oct 22, 2024
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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?
frown.gif

I am hoping this is possible and a sort of easy fix somehow
frown.gif
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Oh, users are using Excel Desktop app to open the workbook since macros aren't supported in Excel Online apparently
 
Upvote 0

Forum statistics

Threads
1,223,107
Messages
6,170,137
Members
452,304
Latest member
Thelingly95

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top