Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unlink a file ??
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unlink a file ??
Download findlink from Bill Manville
http://www.bmsltd.ie/MVP/Default.htm it will do what you want -- Regards, Peo Sjoblom Portland, Oregon "Kane" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unlink a file ??
That was great. Tks . Now that we are at it, how do I unlink or delete a
Macro that is not needed? "Peo Sjoblom" wrote: Download findlink from Bill Manville http://www.bmsltd.ie/MVP/Default.htm it will do what you want -- Regards, Peo Sjoblom Portland, Oregon "Kane" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unlink a file ??
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 "Kane" wrote in message ... That was great. Tks . Now that we are at it, how do I unlink or delete a Macro that is not needed? "Peo Sjoblom" wrote: Download findlink from Bill Manville http://www.bmsltd.ie/MVP/Default.htm it will do what you want -- Regards, Peo Sjoblom Portland, Oregon "Kane" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel file lost | Excel Discussion (Misc queries) | |||
Copy File Automatically on Opening It | Excel Discussion (Misc queries) | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) |