PDA

Click to See Complete Forum and Search --> : Always enable "Macro" during open file in MS Office???


laisengchew
Mar 17th, 2005, 12:53 AM
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
Mar 17th, 2005, 12:29 PM
See my response in your other thread.

Duplicate (http://www.vbforums.com/showthread.php?t=329417)