Hi ianripping,
You can use:
Private Sub Workbook_Open()
If ThisWorkbook.ReadOnly Then ThisWorkbook.Close False
End Sub
MP
"ianripping " a écrit dans le message
de ...
I have a LAN network. I want a command that says if the workbook is
open on another PC by another user then msgbox("Already open") else
open it as normal.
Any ideas?
---
Message posted from http://www.ExcelForum.com/