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


"TTD" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[TTD]

Thanks Tom.