How to remove links to the the old workbook (A) after copying the sheets into a new workbook(B)?

[calc]

I am copying some sheets from A with macros into B. I don't want these macros/formulas to have any linking to the old workbook(A) anymore after it is copied into B. Can someone help me in how to achieve it?

 

[JoeMo]

I am copying some sheets from A with macros into B. I don't want these macros/formulas to have any linking to the old workbook(A) anymore after it is copied into B. Can someone help me in how to achieve it?

What do you want to do with macros and/or formulas in sheets copied to workbook B that refer to sheets in workbook A that aren't copied to workbook B?

 

[calc]

What do you want to do with macros and/or formulas in sheets copied to workbook B that refer to sheets in workbook A that aren't copied to workbook B?

Actually i have to copy all the sheets, kind of merge the A with B.

 

[JoeMo]

Actually i have to copy all the sheets, kind of merge the A with B.

You would need to replace all the references to Book A in Book B. For formulas, using Find and Replace (ctrl+h), for example you might find all formulas that contain: [BookA.xlsm] and replace it with nothing (leave Replace input blank).