View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin Paul Martin is offline
external usenet poster
 
Posts: 114
Default Suppress Update Links dialog AND don't update links

Hi all

I have created an Excel utility that works on the other open workbooks.
When other workbooks are opened, I want to suppress the Update Links
dialog (using Application.AskToUpdateLinks = False) but I also DON'T
want the links to be updated. Users will be on Excel 97. Any
suggestions as to a VBA solution that I can put in the utility which
will be open first?

Thanks in advance

Paul Martin
Melbourne, Australia