Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Macro warning (2000)

    How do you disable the "Macro may contain harmful virus" alert? If it is by code, pleae tell where to put the code. I tried - Application.DisplayAlerts = False but wasn't sure where to put it and if that was enough.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Macro warning (2000)

    You can set the general macro security level in Tools | Macro | Security... If you would set it to Low, you would be able to open workbooks containing macros without being warned. This is NOT recommended, however. In general, Medium is the best setting. You may want to tick "Trust all installed add-ins and templates" in the Trusted Sources tab, to avoid being warned about those all the time.

    For obvious reasons, you cannot change the macro security settings, even temporarily, from within a macro - that would make life too easy for macro virus writers...

Posting Permissions

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