Find a picture on a worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MM User - 10 Nov 2007 17:09 GMT

Hi,

I it possible to serach for a picture on a worksheet via VBA, I'm trying to
see if a particular picture is visible on a worksheet if not then copy from
another another worksheet?

Thanks!

Reply to this Message

Dave Peterson - 10 Nov 2007 17:17 GMT

Maybe...

Do you know the name of the picture--not the filename that you used to insert
the picture--the name that appears in the namebox (to the left of the
formulabar) when you select that picture.

Or maybe by its location???

> Hi,
>
[quoted text clipped - 3 lines]
>
> Thanks!

Signature

Dave Peterson

Reply to this Message

MM User - 10 Nov 2007 17:38 GMT

Thanks Dave, yes I know its name (it will be "panel1")

Regards

> Maybe...
>
[quoted text clipped - 14 lines]
>>
>> Thanks!

Reply to this Message

Dave Peterson - 10 Nov 2007 20:06 GMT

You can use something like:

dim myPict as Picture

set mypict = nothing
on error resume next
set mypict = worksheets("Somesheetnamehere").pictures("Panel1")
on error goto 0

if mypict is nothing then
'it's not there
else
'it's already there
if mypict.visible = false then
'make it visible???
mypict.visible = true
end if
end if

> Thanks Dave, yes I know its name (it will be "panel1")
>
[quoted text clipped - 22 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

MM User - 10 Nov 2007 22:38 GMT

Thanks Dave, thats what I was after!

> You can use something like:
>
[quoted text clipped - 42 lines]
>> >
>> > Dave Peterson

Reply to this Message