Always enable "Macro" during open file????

[laisengchew]

Is there a way for VBA macro to always enable if user open the file?
(Without setting MS Office security to "Low" level")?
It's something like

Dim objExcel As Object

Set objExcel =CreateObject("Excel.Application")

objExcel.DisplayAlert=False... or something like that... I'm not so sure about the code..


Any ideas?
Thanks

[RobDog888]

No, if there was then what would be the sense of having any security at all?

You could get a digital signature and sign the project. Then it would run on high, but if the user disables macros
then it wont run.

[laisengchew]

Thanks RobDog888....

Actually i'm just learning about doing macro in Excel currently. But how can i make my macro autorun like AutoExec when user agree to enable macro run and open my excel files? or in the Word also can...

Is it just name the macro as "AutoExec"
I know it's work in Access MDB but i wonder how should i do it in Excel, MDB or MS Office...


Thanks

[RobDog888]

Use the WorkBook_Open event for Excel, Document_Open for word, etc.