How do you select images progammically
 

Is there a way to select images progammically on an excel sheet. I have a
sheet with several hundred images, each referenced to a given cell in col D.
When I run a filter based on a value in col C I would then like to select
the filtered images progammically, rather than go through each one and
select manually. Ant way this can be done?

Pat

How do you select images progammically
 

Hi Pat,

Look he

http://www.jkp-ads.com/articles/showpicture00.htm

or

http://www.mcgimpsey.com/excel/lookuppics.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pat" wrote in message ...
| Is there a way to select images progammically on an excel sheet. I have a
| sheet with several hundred images, each referenced to a given cell in col D.
| When I run a filter based on a value in col C I would then like to select
| the filtered images progammically, rather than go through each one and
| select manually. Ant way this can be done?
|
| Pat
|
|

How do you select images progammically
 

Thank you Niek for your assistance, unfortunately I only want to find a way
to select all of the filtered images at once and then delete them. I could
hold down the ctrl key and select each one, but that will take me quite a
while.

Pat


"Niek Otten" wrote in message
...
Hi Pat,

Look he

http://www.jkp-ads.com/articles/showpicture00.htm

or

http://www.mcgimpsey.com/excel/lookuppics.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pat" wrote in message
...
| Is there a way to select images progammically on an excel sheet. I have
a
| sheet with several hundred images, each referenced to a given cell in
col D.
| When I run a filter based on a value in col C I would then like to
select
| the filtered images progammically, rather than go through each one and
| select manually. Ant way this can be done?
|
| Pat
|
|

How do you select images progammically
 

If I try:
ActiveSheet.DrawingObjects.Delete
this will delete all images on the sheet both filtered and unfiltered
images.




"Pat" wrote in message
...
Thank you Niek for your assistance, unfortunately I only want to find a
way to select all of the filtered images at once and then delete them. I
could hold down the ctrl key and select each one, but that will take me
quite a while.

Pat


"Niek Otten" wrote in message
...
Hi Pat,

Look he

http://www.jkp-ads.com/articles/showpicture00.htm

or

http://www.mcgimpsey.com/excel/lookuppics.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pat" wrote in message
...
| Is there a way to select images progammically on an excel sheet. I
have a
| sheet with several hundred images, each referenced to a given cell in
col D.
| When I run a filter based on a value in col C I would then like to
select
| the filtered images progammically, rather than go through each one and
| select manually. Ant way this can be done?
|
| Pat
|
|