View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bruce Cooley Bruce Cooley is offline
external usenet poster
 
Posts: 11
Default Disable update links dialog box

If you're making a copy for people who will not be changing the linked
information, or if you just don't need to change the linked information any
more, you can save it as a different filename, break all the links, and then
save again. That way you retain the original file with live links and you
create one without links.

Bruce Cooley


"Sandy" wrote in message
...
: Hello!
:
: I don't want the dialog box that says "The workook you
: opened contains automatic links . . ." "To update all
: linked information, click Yes . . ." to display to the
: user. How do I disable it in code?
:
: Your help will be immensely appreciated!
:
: Sandy