View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
barnabel barnabel is offline
external usenet poster
 
Posts: 119
Default security warning

Well since she said "security warnings" and "stopping the flow" I am assuming
that she is talking about the messages that you are deleting a sheet or
overwriting a file not macros are not enabled

"Ronald Dodge" wrote:

I would hardly think this would work as this is a security matter and Excel
will catch any VBA stuff before it would even attempt to execute the codes,
thus the warning box would still come up prior to this code within her app
being executed.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"barnabel" wrote in message
...
I think what you want is to put this in your macro before any command that
brings up an alert.

Application.DisplayAlerts = False


"Joanne" wrote:

Is there a way to prevent the security warning box from showing up and
stopping the flow of the program without having to give up the security?
I want it to apply only to my little app, not to Excel in general.
Thank you