Nick,
After reading:
http://msdn.microsoft.com/library/de...us/vbaxl10/htm
l/xlproAutomationSecurity.asp

I am confused as well.
Does this mean I can dictate Excel2002 macro security from code,
irrespective of the user's setting ?

As I do not have XL2002 I cannot test.

NickHK


"Nick Hodge" wrote in message
...
Helmekki

That doesn't seem to stop the warning. It had gone past me totally and
reading help appears to state it will work, but I'd be staggered if you
can
actually switch off warnings so simply on something so crucial as macro
security or am I misunderstanding

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"helmekki" wrote
in
message ...

Try this: it will do the job
place this code in the main file then open the other files, so the
codes in the other files will not be excuted.

the code will open the other files and prevent excuting the codes
inside them


Code:
--------------------
Sub Security()
Dim lngAutomation As MsoAutomationSecurity

With Application
lngAutomation = .AutomationSecurity
.AutomationSecurity = msoAutomationSecurityForceDisable
With .FileDialog(msoFileDialogOpen)
.Show
.Execute
End With
.AutomationSecurity = lngAutomation
End With

End Sub

--------------------


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread:
http://www.excelforum.com/showthread...hreadid=384353