View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Leon[_2_] Leon[_2_] is offline
external usenet poster
 
Posts: 25
Default Prevent multiple workbooks in same Excel instance

Hi

I have a workboook which is updated every minute by using the ontime
facility.
It works fine when user not have any other workbook open in the same
intance of Excel.

How do I prevent user from open another workbook in the particular
instance containing the workbook with autoupdate function (ontime)

1) when user tries to open another workbook via the open menu
2) when user dobbleclick on an xls file

Regards