Richard U
Active Member
- Joined
- Feb 14, 2006
- Messages
- 406
- Office Version
- 365
- 2016
- 2010
- 2007
- Platform
- Windows
I have a worksheet that is sometimes opened manually, and sometimes opened through automation.
I want to display a messagebox to the user if they opened it manually, but not if it was called by another spreadsheet.
Is there a way to set a flag or to send a value through application.run to do this?
I want to display a messagebox to the user if they opened it manually, but not if it was called by another spreadsheet.
Is there a way to set a flag or to send a value through application.run to do this?