Question on Application/Workbook

[Les Stout]

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

 

[Jim Rech]

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

 

[Les Stout]

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

Les Stout

 

[Jim Rech]

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
| Thanks Jim, could one make a button on the tool bar to activate it too ?
|
| Les Stout
|
|

 

[Les Stout]

Thanks for your help Jim. have a good evening

Les Stout