Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109397

Re: VBA to delete link to inserted image

Show all headers | View raw

hi Steve,

Sub Macro1()
On Error Resume Next ' for those who have no link
For Each sh In ActiveSheet.Shapes
     sh.Hyperlink.Delete
Next
End Sub

isabelle

Le 2016-10-10 à 04:28, Steve a écrit :
> I have a worksheet which contains a few hundred pictures which have been
> inserted with "Link to file." I want to keep the pictures but NOT have them
> linked. So potentially have vba that copies each picture, then pastes it
> without the link . . .  but I'm sure there's a better way.
>
> Can anyone help please?
>
> Steve
>

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

VBA to delete link to inserted image Steve <Steven@pctamers.eu> - 2016-10-10 01:28 -0700
  Re: VBA to delete link to inserted image Claus Busch <claus_busch@t-online.de> - 2016-10-10 10:43 +0200
  Re: VBA to delete link to inserted image isabelle <i@v.invalid> - 2016-10-10 04:49 -0400
    Re: VBA to delete link to inserted image Steve <Steven@pctamers.eu> - 2016-10-10 02:12 -0700
    Re: VBA to delete link to inserted image Steven@pctamers.eu - 2016-10-10 02:19 -0700
  Re: VBA to delete link to inserted image "Peter T" <askformy@gmail.com> - 2016-10-10 11:55 +0100
    Re: VBA to delete link to inserted image Steve <Steven@pctamers.eu> - 2016-10-10 12:57 -0700

csiph-web