suppress Active X alert
 

I have a macro that runs a Active X add-in. The macro always pauses to ask
if it is okay to use the Active X add-in. How do I get this to stop?

suppress Active X alert
 

Have you tried

Application.DisplayAlerts = False
your code
Application.DisplayAlerts = True


"nevpoe" wrote:

I have a macro that runs a Active X add-in. The macro always pauses to ask
if it is okay to use the Active X add-in. How do I get this to stop?

suppress Active X alert
 

Yes, and it still does not requires me to answer okay to the alerts.

"JMB" wrote:

Have you tried

Application.DisplayAlerts = False
your code
Application.DisplayAlerts = True


"nevpoe" wrote:

I have a macro that runs a Active X add-in. The macro always pauses to ask
if it is okay to use the Active X add-in. How do I get this to stop?

suppress Active X alert
 

I'm afraid I don't have any other suggestions, other than making sure theres
not a command in the VBA code asking if it is okay to use the add-in, such as

Result = Msgbox("Okay to run add-in?", vbyesno)


"nevpoe" wrote:

Yes, and it still does not requires me to answer okay to the alerts.

"JMB" wrote:

Have you tried

Application.DisplayAlerts = False
your code
Application.DisplayAlerts = True


"nevpoe" wrote:

I have a macro that runs a Active X add-in. The macro always pauses to ask
if it is okay to use the Active X add-in. How do I get this to stop?