Copying a sheet from one workbook to another creates a link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I copy a sheet from one workbook to another, the workbook creates a link that I can't get rid of.

Background:
Several years ago someone created a workbook for our company that had macros, dialog boxes, sheets and charts. None of the code was commented and my supervisor wanted to upgrade some of the features. So instead of trying to decifer Excel 4 macro code, I just created a new workbook and wrote all the code in visual basic.
In order to save time, copied the data worksheets (and only the worksheets not the macro sheets) to my new workbook. If I go Edit>Link... in my new workbook I see there is a link back to the original workbook, but if I do a "Find..." on the sheet for the original workbook, I can't find anything. I've also searched the VBA code and all of the other sheets. I even checked for hidden sheets.

Does anyone know how to find the "link" and remove it?
 
Have you tried MVP Bill Manville's excellent FindLink utility?
It's available at MVP Stephen Bullen's page:

http://www.bmsltd.co.uk/MVP/Default.htm

--
hth
Max
-----------------------------------------
Please reply in thread

Use xdemechanik <at>yahoo<dot>com for email
----------------------------------------------------------------------------
Centurion said:
When I copy a sheet from one workbook to another, the workbook creates a link that I can't get rid of.

Background:
Several years ago someone created a workbook for our company that had
Click to expand...
macros, dialog boxes, sheets and charts. None of the code was commented and
my supervisor wanted to upgrade some of the features. So instead of trying
to decifer Excel 4 macro code, I just created a new workbook and wrote all
the code in visual basic.
In order to save time, copied the data worksheets (and only the worksheets
Click to expand...
not the macro sheets) to my new workbook. If I go Edit>Link... in my new
workbook I see there is a link back to the original workbook, but if I do a
"Find..." on the sheet for the original workbook, I can't find anything.
I've also searched the VBA code and all of the other sheets. I even checked
for hidden sheets.
 
Back
Top