View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Question on Application/Workbook

I assume you have startup code running in your workbook. You should add
this line to that code:

Application.IgnoreRemoteRequests = True

Be sure to set this to False in your closing code or the user will not like
you.<g

--
Jim
"Les Stout" wrote in message
...
| Hi all, I have created a recon tool with a lot of script in. I have a
| problem in that, if my doc with the script is open and the user opens
| another excel document it opens in my document, Is there anyway to make
| my document exclusive so that when another document is opened it is in a
| seperate workbook or window, i hope i have explained myself ok.
|
| Your help will be greatly appreciated.
|
| Les Stout
|
| *** Sent via Developersdex http://www.developersdex.com ***