Multiple users updating Excel from windows form

[av123]

Doing what you are describing is difficult, because you would need a "server" type program to "tell" all your users using your program when the form is being worked on, and when it's clear.

What would be much easier to do is to identify and handle the error you're getting on the small chance a user DOES click the "Go" button while the file is open in someone else's program.
As a side note, this is EXACTLY the reason databases were invented.

If you use a Try...Catch...End Try block to handle the error, when a user clicks the button and the program hits that error, instead of crash, you can instead "handle" it by making a popup with something like "The file is currently being updated by another user, please wait a little while and try again"

I can't use any database as my users only want excel and this visual studio form. Can you pleas help me with the code of try catch? I am unable to understand.