Unlink a file ??

[Kane]

How do I unlink a file that no longer requres a link that was used in the
development of a worksheet? The Link popup is always answered NO, but I would
like to eliminate this.

Tks

 

[Peo Sjoblom]

Download findlink from Bill Manville

http://www.bmsltd.ie/MVP/Default.htm

it will do what you want

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Kane]

That was great. Tks . Now that we are at it, how do I unlink or delete a
Macro that is not needed?

 

[Peo Sjoblom]

Open the workbook with the macro, press alt + F11, in the project pane to
the left lookup the workbook name and
see if it has any modules, open it/them, right click the module and select
remove module and when prompted to export answer no, press alt + Q to close
the editor and save the workbook. Now it shouldn't ask if you want to enable
macros upon starting.
If it still does you must have code in either the worksheets or in the
workbook (ThisWorkbook, and the sheet names)
Repeat the alt + F11, double click them to see if there is any code, just
high light and delete all the code, close the editor and save the workbook

--
Regards,

Peo Sjoblom

Portland, Oregon