Results 1 to 4 of 4

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

Threaded View

  1. Mar 17th, 2005, 01:52 AM #1
    laisengchew
    laisengchew is offline

    Thread Starter
    Member
    Join Date
    Dec 2004
    Posts
    39

    Resolved 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
    Last edited by laisengchew; Mar 18th, 2005 at 01:16 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width