View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ricky M. Medley Ricky M. Medley is offline
external usenet poster
 
Posts: 18
Default Identify if another user has spreadsheet open - in VBA

Harald wrote:
You have to open it by code.<<snip


Not necessarily, you could place code on ThisWorkbook code page...

Private Sub Workbook_Open()
If ActiveWorkbook.ReadOnly = False Then 'Means workbook is not read only
'<call your code/function/sub here
End if
End Sub

regards
ricky