+ Reply to Thread
Results 1 to 5 of 5

Display alerts

  1. #1
    ewan7279
    Guest

    Display alerts

    Hi,

    I have a spreadsheet that is sent to users, but contains links to files on
    my personal system. I want the user to open the file, enter relevant data
    and return it to me. However, I don't want the user to see the 'Update
    links?' alert when they open the file.

    I know the application.displayalerts = false can be used in a macro, but how
    can I get the macro to run when the file is opened?

    Thanks,

    Ewan.

  2. #2
    Kevin B
    Guest

    RE: Display alerts

    Open the file that contains the links, click EDIT in the menu and select
    LINKS. In the LINKS dialog box, click the START UP PROMPT command button and
    select either DON'T DISPLAY ALERT AND DON'T UPDATE LINKS or DON'T DISPLAY
    ALERTS AND UPDATE LINKS.



    --
    Kevin Backmann


    "ewan7279" wrote:

    > Hi,
    >
    > I have a spreadsheet that is sent to users, but contains links to files on
    > my personal system. I want the user to open the file, enter relevant data
    > and return it to me. However, I don't want the user to see the 'Update
    > links?' alert when they open the file.
    >
    > I know the application.displayalerts = false can be used in a macro, but how
    > can I get the macro to run when the file is opened?
    >
    > Thanks,
    >
    > Ewan.


  3. #3
    Tom Ogilvy
    Guest

    RE: Display alerts

    It wouldn't make any difference if it did run. the prompt occurs before any
    macros are run.

    If you have excel 2002 or later, go into the Edit=>Links and click the
    button on the lower left of the dialog. If you/your users are in xl2000 or
    earier, you can't control the prompt.

    Might be better to copy the data to a workbook that is not linked and
    distribute that. Then retrieve the data from the returned workbook.

    --
    Regards,
    Tom Ogilvy


    "ewan7279" wrote:

    > Hi,
    >
    > I have a spreadsheet that is sent to users, but contains links to files on
    > my personal system. I want the user to open the file, enter relevant data
    > and return it to me. However, I don't want the user to see the 'Update
    > links?' alert when they open the file.
    >
    > I know the application.displayalerts = false can be used in a macro, but how
    > can I get the macro to run when the file is opened?
    >
    > Thanks,
    >
    > Ewan.


  4. #4
    ewan7279
    Guest

    RE: Display alerts

    Thanks Kevin

    "Kevin B" wrote:

    > Open the file that contains the links, click EDIT in the menu and select
    > LINKS. In the LINKS dialog box, click the START UP PROMPT command button and
    > select either DON'T DISPLAY ALERT AND DON'T UPDATE LINKS or DON'T DISPLAY
    > ALERTS AND UPDATE LINKS.
    >
    >
    >
    > --
    > Kevin Backmann
    >
    >
    > "ewan7279" wrote:
    >
    > > Hi,
    > >
    > > I have a spreadsheet that is sent to users, but contains links to files on
    > > my personal system. I want the user to open the file, enter relevant data
    > > and return it to me. However, I don't want the user to see the 'Update
    > > links?' alert when they open the file.
    > >
    > > I know the application.displayalerts = false can be used in a macro, but how
    > > can I get the macro to run when the file is opened?
    > >
    > > Thanks,
    > >
    > > Ewan.


  5. #5
    ewan7279
    Guest

    RE: Display alerts

    Thanks Tom.

    "Tom Ogilvy" wrote:

    > It wouldn't make any difference if it did run. the prompt occurs before any
    > macros are run.
    >
    > If you have excel 2002 or later, go into the Edit=>Links and click the
    > button on the lower left of the dialog. If you/your users are in xl2000 or
    > earier, you can't control the prompt.
    >
    > Might be better to copy the data to a workbook that is not linked and
    > distribute that. Then retrieve the data from the returned workbook.
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "ewan7279" wrote:
    >
    > > Hi,
    > >
    > > I have a spreadsheet that is sent to users, but contains links to files on
    > > my personal system. I want the user to open the file, enter relevant data
    > > and return it to me. However, I don't want the user to see the 'Update
    > > links?' alert when they open the file.
    > >
    > > I know the application.displayalerts = false can be used in a macro, but how
    > > can I get the macro to run when the file is opened?
    > >
    > > Thanks,
    > >
    > > Ewan.


+ 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