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 *** |
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 *** |
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 *** |
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 *** |
Question on Application/Workbook
Thanks for your help Jim. have a good evening
Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com