Stop Link Update
 

I am using three workbooks- a master control workbook, a back-up copy and a
working copy. The following code open the back-up copy, changes it to in
Process and then opens the working copy. Works fine- my problem is that there
is a link in the master control workbook that refers to a value in first
copy. On the second save Excel automatically updates the link in the master
file to refer to the second save. How can I make the link static?

Code in use:

Workbooks.Open Filename:=netwrkpath
Set branchbook = ActiveWorkbook
Sheets("RegionalControl").Range("f12").Value = "IN PROCESS!"
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:=netwrkpath2 '(THIS STEP IS WHERE THE LINK IS
SWITCHED)
Application.Run (macrname)

--
Paul