How to determine an opened sheet( Read Only)

[TTD]

Hi,

when someone opens a workbook which already was opened by someone else, the
person gets a dialogbox, inwhich (s)he can select 'read only'.

But when the user opens the workbook through a script, the user is not
warned.

I want to stop the script if the opened workbook was already opened by
someone else.

How do I determine this?

Thanks

 

[Tom Ogilvy]

http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open

 

[TTD]

Thanks Tom.