VBA excel -- When a VBAProject is clicked or double-clicked, it will trigger a macro. <<<< Is there any way to do that? How to determine if my VBAProject is clicked or double-clicked? A user could open the VB Editor to click on other VBA projects, ok fine... but when the user clicks or double-clicks on my VBAProject, it will trigger a macro <<< Possible to do this? How? Thank you in advance.
Any macro could never be triggered by Click the VABProject.
Sheet, Code, Workbook, User Form and Class are the possible modules to RUN the macro.
Click event can be used as,
- Worksheet Click
- Cell Click
- Command Button Click
- Sheet TAB Click
To automate the macro you may think for,
- Workbook/Sheet/User Form, Load Event.
- Auto Open Event when Excel starts.
- RUN macro without load the Excel using VB Script file.