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.
|