Help when printing rows and objects in Excel
Help when printing rows and objects in Excel
(OP)
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?
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."
Talk To Other Members
RE: Help when printing rows and objects in Excel
Rows("6:9").EntireRow.Hidden = True
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson
RE: Help when printing rows and objects in Excel
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."
RE: Help when printing rows and objects in Excel
https://learn.microsoft.com/en-us/javascript/api/e...
RE: Help when printing rows and objects in Excel
combo