MichaelSchulz
Board Regular
- Joined
- Apr 10, 2014
- Messages
- 64
I have a workbook with ActiveX controls that works fine. There is a Workbook_Open code in ThisWorkbook.
The problem is when another user opens the workbook for the first time. The user receives the security message for enabling ActiveX controls but, at the same time, the Workbook_Open routine is attempting to run.
The result is a run-time error.
Once the ActiveX enabled, the workbook opens without a problem and the Workbook_Open code fires off as intended.
Is there a way to keep the routine from running until after the user enables ActiveX?
The problem is when another user opens the workbook for the first time. The user receives the security message for enabling ActiveX controls but, at the same time, the Workbook_Open routine is attempting to run.
The result is a run-time error.
Once the ActiveX enabled, the workbook opens without a problem and the Workbook_Open code fires off as intended.
Is there a way to keep the routine from running until after the user enables ActiveX?