Two users simultaneously opening a spreadsheet

  • Thread starter Thread starter boe
  • Start date Start date
B

boe

Two users want to open a spreadsheet simultaneously. They are connected to
a Windows 2000 server. Sometimes they will get notice that it is already
open and it is read only. Sometimes they don't. How do we make sure they
get notification.

Thanks
 
This is what I ended up putting in my Workbook_Open event:

ActiveSheet.Select
If Me.ReadOnly Then
Result = MsgBox("Are you sure that you want to open this spreadsheet
in Read_only? You won't be able to save any changes that you make!",
vbCritical + vbApplicationModal + vbYesNo, "Read-Only Warning")
If Result = vbNo Then
Me.Close False
End If
End If
 
Back
Top