Copy Worksheet from one Worbook to another without copying back links

[Warbe]

Copying a complete sheet from one Workbook to another looks like a simple task in the first place. A copy may however hav links back to the source which Microsoft tells "works as designed". The function below avoids this. The only precondition: The sheet must not already exist in the target Workbook.

Please Login or Register  to view this content.

The function is part of my Code Module Management, where it mimics what Export, Remove, Import does to transfer a non Data Module (Class Module, Standard Module, and UserForm).