View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TTD TTD is offline
external usenet poster
 
Posts: 5
Default 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