Unlink a file ??

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

Guest

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
 
That was great. Tks . Now that we are at it, how do I unlink or delete a
Macro that is not needed?
 
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
 
Back
Top