suppress Active X alert

N

nevpoe

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?
 
J

JMB

Have you tried

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

JMB

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)
 
Top