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

Download findlink from Bill Manville

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

it will do what you want

--
Regards,

Peo Sjoblom

Portland, Oregon




"Kane" <Kane@discussions.microsoft.com> wrote in message
news:D8CBA392-7721-4C5C-B474-55BA8EEC839D@microsoft.com...
> 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?

"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" <Kane@discussions.microsoft.com> wrote in message
> news:D8CBA392-7721-4C5C-B474-55BA8EEC839D@microsoft.com...
> > 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
>
>

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" <Kane@discussions.microsoft.com> wrote in message
news:300CDC5C-EF07-475D-BE7A-3E123B7F125D@microsoft.com...
> 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" <Kane@discussions.microsoft.com> wrote in message
>> news:D8CBA392-7721-4C5C-B474-55BA8EEC839D@microsoft.com...
>> > 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
>>
>>