excel vba macros with multiple users and sharepoint

Originally Posted by iwest05

Here's my situation i have 5 different print departments (Color, Black/White, Shipping, Dock, Mail Print) all entering in different information, based upon the computers name is what tells excel which macro to open. The File is in share-point so there are multiple users who can access this file. I run into problems when someone changes the workbook while someone else has a macro open and they dont reopen the file. Is there anyway to avoid that? A way to make the workbook read only when a macro is open and read/write when there are no macros open? I've been looking and reading that some people have made an Access database and just used excel for the macros but wanted to get someones opinion on how to avoid this error in the future how to fix it before it happens again.

VBA is a work in progress for me so i know i have things to learn when it comes to the code

I'm confused? A workbook will always open as read only if somebody is already accessing the file, and it will alert you as such when you open the workbook, so it should not be possible for anyone else to change anything while the workbook is open, regardless if a macro is running or not. The only option someone has when editing a read only workbook is to create another copy.

Originally Posted by iwest05

If that is the case this workbook doesn't open in read only. When im in it i can see someone else changing data as im doing the same thing
we use share point, teams and office 360

Ah my apologies, I miss the part about SharePoint. That would be where your problem lies. If possible I'd edit the title to include SharePoint, as it's a niche part of VBA so would need some experienced eyes to take a look.