View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marcelo[_3_] Marcelo[_3_] is offline
external usenet poster
 
Posts: 1
Default Avoid to reopen a working Workbook

I have a program developed in VBA over EXCEL which does not have t
allow to open another session of itself, that is, if a user opens th
book that contains the program, and once opened, he or she (the user
tries to open the same book again, first of them (first sessio
Workbook) does not have to allow to open the second one, all thi
without disturbing the normal EXCEL operation with other EXCE
workbooks.

In other words, I want to allow the User to open the Workbook
financial.xls only once at a time. (avoid reopen)

Another explanation:

How do I restrict the user to open a workbook only one time until it i
closed?

Thanks

Marcelo

--
Message posted from http://www.ExcelForum.com