Hi all,

I have researched this but can't seem to find anything that works for me. I have tinkered.

I have an Excel file (xlsm) on a shared network. Quite simply (ahem!) I want to determine if the file is open (in any guise - read only, etc) from another workbook.

If open Then MsgBox("Open")

ElseIf: MsgBox("Closed")
Something like that anyway.