I'm still really new to VB, but I'm writing a macro which copies data from spreadsheet to another when a submit button is clicked.
However, because two people could be trying to do this at the same time, I want to include at the beginning of the macro a process where it checks whether the file needed is already open by someone else.
If the file is open, I need it to create a message box asking the user to try clicking submit again in a couple of minutes, with the vbOKonly option.
If the file is not already open, I want the macro to continue running.
Any help would be much appreciated, as I'm going round in circles :-)