Workbook_Open when ActiveX not yet enabled

[MichaelSchulz]

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?

 

[Jaafar Tribak]

Have you considered using an error handler in the workbook open event ?

Something like this :

Private Sub Workbook_Open()
On error Resume Next

If err.number = (Look up the error number you are getting) Then Exit Sub

.... Rest of the code goes here ....

End Sub

 

[MichaelSchulz]

Have you considered using an error handler in the workbook open event ?

Something like this :

Private Sub Workbook_Open()
On error Resume Next

If err.number = (Look up the error number you are getting) Then Exit Sub

.... Rest of the code goes here ....

End Sub

That would solve part of the problem as it stands now. A first-time user could then enable ActiveX but the bit of code in Workbook_Open still would not have ran.

To phrase the issue in another way:
How can I have a subroutine run after the user has opened the workbook—and after a first-time user has enabled ActiveX—but before the user does anything else?