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

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

Re: VBA to delete link to inserted image

Show all headers | View raw

Hi Isabelle

thanks for the quick response. I was wondering if this will also work if the link is to an inserted object, as these aren't hyperlinks (I don't think they are!?)? 

Steve

On Monday, 10 October 2016 09:49:41 UTC+1, isabelle  wrote:
> 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