share excel file problem

  • Thread starter Thread starter Michele
  • Start date Start date
M

Michele

Hello , i am an italian technical
i have this problem:
- i have a server (windows2000) and one file excel
- two users (user A and user B)

scenario:
user A open file excel
user B open file excel and Excel DON'T SEE A MESSAGE FOR ALERT USER that
user A work with this file.

user b save the work and LOST IT !!

thank and scuse for my english
 
I had the same problem so on the workbook_open event I put this code:

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

That way the user gets a second box telling them what is happening.

Rui
 
Back
Top