Always enable "Macro" during open file????
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
Re: Always enable "Macro" during open file????
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.
Re: Always enable "Macro" during open file????
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
Re: Always enable "Macro" during open file????
Use the WorkBook_Open event for Excel, Document_Open for word, etc.