You cannot force a system with "high security settings" to run your code.
Think about it. First, how would that code run if the security settings stop
code from running? Second, if you were able to do that, it would defeat the
purpose of having security settings in the first place. If your user is to
be able to run your macros, they will have to adjust their Excel settings to
either permit macros to run directly (not advisable) or to prompt them if it
is alright to run macros (better).

--
Rick (MVP - Excel)


"Curt" wrote in message
...
After all this time I have a program that does fine on my comp. When I put
it
on another it says go to online help for macros enable. On my comp when I
open it asks to enable. Is there any code that I can put into excel to
have
it enable when opening or to display screen that allows enable. Have
become
aware of security settings. Assumeing they are high on foreign comp.
Thanks for any assistance.