View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Issue with Autofilter and Pictures

In my simple tests (in xl2003), the pictures behaved nicely.

Are you positive that the pictures are contained within the cell (or row).

Maybe showing the gridlines (tools|Options|view tab) would help verify this???

J_Mori wrote:

I am having trouble keeping my pictures in their cells with the Autofilter
function. Some pictures will move. It mainly happens when I apply more than
1 filter.

Here's an example set up:
Date / Picture / Event / Print Date /# of copies needed / Copy given to
client 1/ copy given to client 2/client 3/

The pictures are all different sizes, I've put the setting on my 100
pictures that says move with cell and size with cell. It still moves. Then
I filter by Event, then print date and pictures stack on top at the bottom
(not all but some). I can have a few filters.

I saw a post already on this issue, but saw no real solution to this
situation.
Anyone else see the issue? Found a resolution?


--

Dave Peterson