Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Application/Workbook
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Application/Workbook
Thanks Jim, could one make a button on the tool bar to activate it too ?
Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Application/Workbook
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 *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Application/Workbook
Thanks for your help Jim. have a good evening
Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.UserName Question | Excel Discussion (Misc queries) | |||
Application.ScreenUpdating function question | Excel Worksheet Functions | |||
Question on application.screenupdating | Excel Programming | |||
Application.Inputbox Question | Excel Programming | |||
Application.Run question | Excel Programming |