Printing conditional images

[Trav]

All,

I am certain there's a simple answer to this but it has been baffling
me so I'm throwing it open to the world after searching the archives
with little success.

In my worksheet, I have inserted images conditional on cells containing
certain values. The code is as follows:

~~~~~~~~~~~~
Private Sub Worksheet_Calculate()
Me.Shapes("Picture 1").Visible = (Range("C14") = 2)
Me.Shapes("Picture 2").Visible = (Range("C23") = 5.76)
End Sub
~~~~~~~~~~~~

The images appear without any problem and all is well on-screen.
However, I cannot get the images to print and I am unsure as to how to
fix this. I've checked the image properties and the "print object" box
is checked so it would seem that it should print but doesn't. What's
the simple thing I am overlooking which will make those images appear
when printed?

Thanks in advance!

[Dave Peterson]

Do the pictures show up in file|Print preview?

If yes, then it's not excel. Maybe try a different printer or get a newer
driver for the existing printer???


Trav wrote:
>
> All,
>
> I am certain there's a simple answer to this but it has been baffling
> me so I'm throwing it open to the world after searching the archives
> with little success.
>
> In my worksheet, I have inserted images conditional on cells containing
> certain values. The code is as follows:
>
> ~~~~~~~~~~~~
> Private Sub Worksheet_Calculate()
> Me.Shapes("Picture 1").Visible = (Range("C14") = 2)
> Me.Shapes("Picture 2").Visible = (Range("C23") = 5.76)
> End Sub
> ~~~~~~~~~~~~
>
> The images appear without any problem and all is well on-screen.
> However, I cannot get the images to print and I am unsure as to how to
> fix this. I've checked the image properties and the "print object" box
> is checked so it would seem that it should print but doesn't. What's
> the simple thing I am overlooking which will make those images appear
> when printed?
>
> Thanks in advance!

--

Dave Peterson

[Trav]

Dave,

The images do not appear in the Print Preview. However, I've tried the
file on three separate computers connected to three separate printers
and the result is the same each time (images don't print or appear in
Print Preview). I was thinking along the lines that perhaps it's
because they are conditional images that they do not appear in the
Print Preview. My reasoning is that the same images inserted into the
worksheet as basic pictures (ie. non-conditional) appear in Print
Preview and print without problem.

Trav.


Dave Peterson wrote:
> Do the pictures show up in file|Print preview?
> If yes, then it's not excel. Maybe try a different printer or get a newer
> driver for the existing printer???

[Dave Peterson]

But once the pictures are there, they don't know how they got there.

Are you sure you clicked "Print" for all the pictures?

Trav wrote:
>
> Dave,
>
> The images do not appear in the Print Preview. However, I've tried the
> file on three separate computers connected to three separate printers
> and the result is the same each time (images don't print or appear in
> Print Preview). I was thinking along the lines that perhaps it's
> because they are conditional images that they do not appear in the
> Print Preview. My reasoning is that the same images inserted into the
> worksheet as basic pictures (ie. non-conditional) appear in Print
> Preview and print without problem.
>
> Trav.
>
> Dave Peterson wrote:
> > Do the pictures show up in file|Print preview?
> > If yes, then it's not excel. Maybe try a different printer or get a newer
> > driver for the existing printer???

--

Dave Peterson

[Trav]

Absolutely positive. Even though I was 100.3% sure, I just went and
checked again and now I'm 100.4% certain.

[Trav]

Oh .... poop. I've just realised what's happened and I'm not happy -
I'm feeling rather ashamed about this admission.

The original file I was working on had the page setup to exclude
certain columns from printing. I altered that as the first thing I did
before I went to work on modifying it since I knew that would be a
problem. At a point during the middle of the construction I sent it to
a colleague who reviewed it and sent it back to me. In the process of
this emailing, I've somehow managed to overwrite the emailed file with
the original file I think, because the page print setup limitation is
back. I know that I changed this because I tested it immediately
afterward so it's not just a case of me not doing it correctly the
first time - it's a case of me using an old version of the file which
meant I didn't even think to adjust a setting I *knew* that I had
adjusted since it was the first step I'd taken.

I apologise for overlooking something so simple and wasting your brain
cells thinking about my printer drivers...*slinks away into the corner
to put on the big conical hat*

[Dave Peterson]

But you found it, so that's a good thing.

Trav wrote:
>
> Oh .... poop. I've just realised what's happened and I'm not happy -
> I'm feeling rather ashamed about this admission.
>
> The original file I was working on had the page setup to exclude
> certain columns from printing. I altered that as the first thing I did
> before I went to work on modifying it since I knew that would be a
> problem. At a point during the middle of the construction I sent it to
> a colleague who reviewed it and sent it back to me. In the process of
> this emailing, I've somehow managed to overwrite the emailed file with
> the original file I think, because the page print setup limitation is
> back. I know that I changed this because I tested it immediately
> afterward so it's not just a case of me not doing it correctly the
> first time - it's a case of me using an old version of the file which
> meant I didn't even think to adjust a setting I *knew* that I had
> adjusted since it was the first step I'd taken.
>
> I apologise for overlooking something so simple and wasting your brain
> cells thinking about my printer drivers...*slinks away into the corner
> to put on the big conical hat*

--

Dave Peterson