Two users simultaneously opening a spreadsheet

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
 
T

Township of East Hanover

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
 
Top