×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help when printing rows and objects in Excel

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?

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

If you do not want rows 6 to 9 to be printed, can't you just do (with a little VBA):

Rows("6:9").EntireRow.Hidden = True


ponder

---- Andy

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

RE: Help when printing rows and objects in Excel

(OP)
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."

RE: Help when printing rows and objects in Excel

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close