How to determine an opened sheet( Read Only)
 

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

How to determine an opened sheet( Read Only)
 

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
--
Regards,
Tom Ogilvy


"TTD" wrote in message
et...
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

How to determine an opened sheet( Read Only)
 

Thanks Tom.