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.