Links Deleting
 

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

Links Deleting
 

Hi Philippe,

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

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


---
Regards,
Norman


wrote in message
oups.com...
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

Links Deleting
 

Hi Phillipe,

see help for breaklink method.

Regards,
Ivan

Links Deleting
 

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 :
Hi Phillipe,

see help for breaklink method.

Regards,
Ivan