Links Deleting

[pub.berard]

Good Morning,

I would like to know if there is a way to repeat by VBA what we can do
by the menu : Edit - Links - Cut links (in French : Edition - Liaisons
- Rompre les liaisons),

Apart from looking in each cell for formula including caracters like
"=[", which can be long in large sheets.

Thanking you by advance for your help,

Best regards,

Philippe

 

[Norman Jones]

Hi Philippe,

Try Bill Manville's FindLink Addin which may be downloaded, free of charge,
at:

http://www.oaltd.co.uk/MVP/Default.htm

 

[Ivan Raiminius]

Hi Phillipe,

see help for breaklink method.

Regards,
Ivan

 

[Philippe]

Good evening (from France)

Thank you Norman for the link and Ivan for the reference in the help :
it's exactly what I am looking for (and what Excel refuses to
automatically generate with the "macro recorder"!).

Best regards

Philippe

Ivan Raiminius a écrit :