Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Annoying Macro Msg. (Excel 2000)

    Does anyone know how to progmatically bypass the dialog message that appears when you open a workbook that contains macro's?

    Thanks,
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Annoying Macro Msg. (Excel 2000)

    The message is due to Microsofts attempt at virus checking.
    If you are confident that your virus checker software is reliable you can remove the check by going to the Tools menu, Macro, security settings and then set the option to low.

    Note that changing this setting for excel will alter the setting for Word etc too.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Annoying Macro Msg. (Excel 2000)

    Now, that would really defeat the whole purpose of the message wouldn't it. If that were possible, then all the virus writers would have to do is turn it off. The message is displayed before any VBA code is executed and can not be eliminated by code.
    Legare Coleman

Posting Permissions

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