ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to know if Excel is called by another Office app like Word (https://www.excelbanter.com/excel-programming/340198-how-know-if-excel-called-another-office-app-like-word.html)

Balex

How to know if Excel is called by another Office app like Word
 
Hi,

I have developed, in an Excel template, a macro which should only run when
Excel is used interactively. If Excel is called because somebody has embedded
a worksheet ina Word document, and a user starts Word, which starts Excel to
update the Word document with the newest content of the linked worksheet, I
don't want that macro to run. How can I know, in that macro, if Excel has
been starte by Word, and not by a user ?

Thanks for help.
Balex


All times are GMT +1. The time now is 06:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com