Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help when printing rows and objects in Excel

Status
Not open for further replies.
Scott24x7

Scott24x7

Programmer
Jul 12, 2001
2,828
JP
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.
 
Sort by date Sort by votes
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]

[ponder]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
723
SkipVought
S
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
536
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
481
SkipVought
S
zinderellie
  • Locked
  • Question
Excel 365- Formula Help - When A1=X and B1=Y, Return C1
Replies
8
Views
607
dgillz
dgillz
remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
431
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top