changing an excel workbook on one computer from an excel workbook on a different computer

[Computerman]

At work we use an excel spreadsheet to keep track of which process we are at for multiple sites. As only one person can access a workbook at a time, I created multiple single user workbooks that can Sync to and from a 'Master' workbook. That part works fine. What I want to do now is when one person syncs to the master workbook I want a flag to display on all the other users workbooks forcing them to sync From the Master workbook before they can make a change and then sync to the master workbook. Here is the code I wrote to do this

'Send Master Tracked has changed to the other users
Set KARProcessTrackerCierra = ActiveWorkbook
KARProcessTrackerCierra.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerCierra.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerCarisa = ActiveWorkbook
KARProcessTrackerCarisa.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerCarisa.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerRay = ActiveWorkbook
KARProcessTrackerRay.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerRay.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerAshley = ActiveWorkbook
KARProcessTrackerAshley.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerAshley.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerGeorge = ActiveWorkbook
KARProcessTrackerGeorge.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerGeorge.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerRo = ActiveWorkbook
KARProcessTrackerRo.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerRo.xlsm" Then
        Call SheetParameters
    End If
Next wb

When I run this among two different users on my system it works fine the flag appears on the other users workbook when the other workbook does a Sync to the Master Workbook. But is this possible to do across two different computers, which are on the same network. In testing I put a break point on the line that has Carisa as the user. As I cycled the code it found the master workbook and my workbook but not Carisa's (she was the only one with her copy of the process tracker open, so was the only one I expected to see). So my questions are: Is what I am trying to do even possible, and if so, what should I change in my code to make it work?
If you have made it this far, thank you for taking the time to read this and I hope that I made it clear what I am trying to accomplish.

Computerman

 

[SpillerBD]

The code will run on the local application, yours, but not Carisa's. If she has her file open, then it will be locked and unavailable for your sessions macro to evaluate.
The WebApp provides the sync functionality you are looking for.

However the overall task is not a good fit for Excel. There are several Access templates that are good.
A shared OneNote binder has advantages too when the Tags and Tasks are considered.

The master can be a reporting document. Get & Transform makes it easier but the combining by macro is okay. Then opening by multiple people is okay as it should refresh on open and save so the first person to open updates and all other simultaneous views see latest update. Have a updated date/time displayed.