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 ***

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 ***

Thanks Jim, could one make a button on the tool bar to activate it too ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

You certainly could. There is no control built into Excel for this exact
purpose so you'd have to use a custom button and assign your macro to it via
the button's OnAction property

--
Jim
"Les Stout" wrote in message
...
| Thanks Jim, could one make a button on the tool bar to activate it too ?
|
| Les Stout
|
| *** Sent via Developersdex http://www.developersdex.com ***

Thanks for your help Jim. have a good evening

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***