Private Sub Workbook_Open()
Application.DisplayAlerts = False
If ThisWorkbook.ReadOnly Then
MsgBox "The file is already open. Try again later...", vbInformation
ThisWorkbook.Close False
End If
Application.DisplayAlerts = True
End Sub
ASKER
ASKER
ASKER
ASKER
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
TRUSTED BY
ASKER
which still allows the second user to open the file. We want to prevent two people from being in the file at the same time.
Any ideas whether or not the standard Excel dialog box above can be bypassed?