security warning

[Joanne]

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

 

[Ronald Dodge]

In that case, about the only way would be to have a digital signiture
applied to your application. I have attempted to use the self signing
method that comes with MS Office, but it has served me no purpose as I still
ran into the same issue, due to the fact that the self signing method is
still considered as "NOT" trusted. Therefore, if one is needed, you about
would need to get a digital signiture from a vendor (Certificate
Authorization) that issues such digital signitures, which is not cheap by
any means, as it can cost you something like $100 per project or might be
able to get by as small as $400 per year.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

 

[Guest]

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

Application.DisplayAlerts = False

 

[Ronald Dodge]

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

 

[Guest]

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

 

[Guest]

Hi Joanne,

Yes, you can. But, you would need a second loading file for distribution. If
you use automation to open an Excel file, security (and the shift key by
pass) is bypassed and all macros run like normal, even if the user has
security set to Very High.

The trick is to have a VBScript loading file that the user opens first, this
file then uses automation to open the real XL file which can be stored in a
shared area on the network. Distribute the VBScript file to the users (all
users need permission to access the shared network area) and you're done.

HTH