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.