The next step in your education is writing macros

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
Thanks,

I'll give it a try. I'm very familiar with macros, but mainly via
recording
them. I can't write them from scratch, and that's what the suggestion
looked
like.

Thanks again,

Steve

"Dave Peterson" wrote:

Exactly like a macro.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Steve wrote:

Does this go in the Visual basic modules like a macro ?

"Don Guillett" wrote:

Sub BreakLinks()'Bob Umlas
LNames = ActiveWorkbook.LinkSources(xlExcelLinks)
For i = 1 To UBound(LNames)
ActiveWorkbook.BreakLink Name:= _
LNames(i), Type:=xlLinkTypeExcelLinks
Next
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
I copy the data from a sheet I did not create, and apparently it has
numerous
links in it. I have to individually Edit-Links-Break Links many,
many
times.
Is there a way I can do something that will break all the links in
one
shot ?
( I do not want to paste-values to not get the links).

Thanks,

Steve



--

Dave Peterson