Thread: removing links between workbooks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dq dq is offline
external usenet poster
  
Posts: 46
Default removing links between workbooks
Hello Matt,

This won't happen if you copy the sheets all at the same time
e.g. Sheets(Array("Sheet2", "Sheet1")).Copy
or ActiveWindow.SelectedSheets.Copy

DQ

Reply With QuoteReply With Quote