View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karti Karti is offline
external usenet poster
 
Posts: 3
Default Automatically use or update links between two sheets using VBA?

I have two worksheets on different servers and because they have links
you are asked to update the links before you continue.

Is there a way to use VBA to automatically update this link without
the message window opening up?

I need to remove the message window because it confuses my users!

Any and all help is appreciated!

Regards

Karti
;)