Help when printing rows and objects in Excel

[Scott24x7]

Hi All,
In VFP there is a "Print when" conditional when outputting to a a printed report.
I'm looking for something/some way similar to do this in Excel (Office 365 but as PC application, not browser based).
Is this possible?
There are some rows I only want to print (to PDF or to printed document) when a condition is true. (For example, I only want an image object to print when the currency type is JPY, I only want two rows to print when the currency type is JPY, for all other currency types I want to hide them).
Is this possible?


Best Regards,
Scott
MSc ISM, MIET, MASHRAE, CDCAP, CDCP, CDCS, CDCE, CTDC, CTIA, ATS, ATD

"I try to be nice, but sometimes my mouth doesn't cooperate.

 

[Andrzejek]

If you do not want rows 6 to 9 to be printed, can't you just do (with a little VBA):
[tt]
Rows("6:9").EntireRow.Hidden = True[/tt]



---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[Scott24x7]

That could work for my row issues.
What about an image?


Best Regards,
Scott
MSc ISM, MIET, MASHRAE, CDCAP, CDCP, CDCS, CDCE, CTDC, CTIA, ATS, ATD

"I try to be nice, but sometimes my mouth doesn't cooperate.

 

[mintjulep]

Images are sort of shapes, and shapes have a .visible property.

https://learn.microsoft.com/en-us/javascript/api/excel/excel.image?view=excel-js-preview

 

[combo]

Shapes have also .PrintObject property, if set to false, image is still visible, but not printed (also possible to set manually from UI, print object property in formatting object pane).

combo