View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default AskToUpdateLinks

No. This query is made before any code runs.

--
Regards,
Tom Ogilvy

wrote in message
...
Is there anyway I can catch the event when the following
dialog pops up?

The workbook you opened contains automatic links to
information in another workbook. Do you want to update
this workbook with changes made to the other workbook?
- To update all linked information, click Yes.
- To keep the existing information, click No.

And can I catch the Yes or No response from the user?

Thanks.