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.

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.

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.

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.

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.