+ Reply to Thread
Results 1 to 3 of 3

How to stop message popping up before open the excel?

  1. #1
    Registered User
    Join Date
    11-21-2005
    Posts
    5

    How to stop message popping up before open the excel?

    Hi,

    I have to add "Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Me.Saved = True
    End Sub"

    in the excel macros editor. After I added it, it will keep prompting the message to users:
    "The document you are opening contains macros. Some macros may contain harmful viruses. If you are sure this document is from a trusted source, click Yes. If you are not sure and want to prevent any macros from running, click No."

    How to stop this message coming up permanently?

    Thank you.

  2. #2
    Gord Dibben
    Guest

    Re: How to stop message popping up before open the excel?

    Either set your Macro Security level to Low, which is not recommended or get a
    digital certificate/signature and sign the project.

    If just for your own computer, Microsoft Office Tools has a SelfCert function.

    You can create a signature to use on your own computer only.


    Gord Dibben MS Excel MVP

    On Wed, 2 Aug 2006 14:37:28 -0400, jenhu
    <jenhu.2bxe8t_1154544007.236@excelforum-nospam.com> wrote:

    >
    >Hi,
    >
    >I have to add "Private Sub Workbook_BeforeClose(Cancel As Boolean)
    >Me.Saved = True
    >End Sub"
    >
    >in the excel macros editor. After I added it, it will keep prompting
    >the message to users:
    >"The document you are opening contains macros. Some macros may contain
    >harmful viruses. If you are sure this document is from a trusted source,
    >click Yes. If you are not sure and want to prevent any macros from
    >running, click No."
    >
    >How to stop this message coming up permanently?
    >
    >Thank you.



  3. #3
    Registered User
    Join Date
    11-21-2005
    Posts
    5
    Thank you, so there is no way to stop message prompting on user's machine and I need to have all users change the setting on their pc's?
    Last edited by jenhu; 08-03-2006 at 09:38 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1