View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default 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?