 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / July 2007Excluding blank pages in Excel worksheet printout
Hello Folks, I have created a worksheet that offers users to print out a finalised document. The sheet list various questions one of which is, How many family members are there and for the names, addresses, contact numbers etc to be entered into various cells. By selecting a radio button to inform of the number of family members, a macro then produces enough records to be filled in for each of the family members. This is a simple macro that basically unhides rows containing enough records for 10 family members so that if you select 2 then only two records are revealed to be filled in. When printing out the finished document, how can I exclude those hidden rows from the printed version of the document? As it is now, blank sheets are included in the printouts, which kind of defeat the object of saving paper. Any help would be greatfully welcome. I hope I haven't confused you with my explanation. Many thanks in advance, Pat Convey. On 7/26/07 1:52 PM, in article 7EE98932-0472-45BD-8315-697FBC4B92EA@microsoft.com, "Pat Convey" <PatConvey@discussions.microsoft.com> wrote: > Hello Folks, > [quoted text clipped - 21 lines] > > Pat Convey. Ok, you've hidden rows, but they print anyway? Is this correct? If so, it's completely abnormal. Do the rows show in print preview? Are you sure you have the latest printer driver?  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Hello Bob, Thanks for the reply. The hidden rows do NOT show in print preview but the rows in question are located in the central portion of the worksheet. So when you view in print preview mode, there is a gap where the hidden rows would be if unhidden. All print drivers are OK. Regards, Pat Convey. > On 7/26/07 1:52 PM, in article > 7EE98932-0472-45BD-8315-697FBC4B92EA@microsoft.com, "Pat Convey" [quoted text clipped - 28 lines] > completely abnormal. Do the rows show in print preview? Are you sure you > have the latest printer driver? On 7/26/07 6:20 PM, in article 132F6B7C-AB47-46E6-8D35-6D8867B42144@microsoft.com, "Pat Convey" <PatConvey@discussions.microsoft.com> wrote: > Hello Bob, > [quoted text clipped - 9 lines] > > Pat Convey. This still is not "normal". Hidden rows should be hidden and not show at all, and not leave space in the page. Double check the print drivers to make sure they are current, check that the print quality is set to highest, and/or try with another printer. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom Thanks Bob. > On 7/26/07 6:20 PM, in article > 132F6B7C-AB47-46E6-8D35-6D8867B42144@microsoft.com, "Pat Convey" [quoted text clipped - 18 lines] > sure they are current, check that the print quality is set to highest, > and/or try with another printer. What version of Excel are you using? What printer are you using? What OS are you using? What exactly is in the hidden rows? Todd Aton Macintosh Business Unit Microsoft Corporation On 7/27/07 5:00 PM, in article 70FAF795-DFF4-4489-92A4-F2AA878231B5@microsoft.com, "Pat Convey" <PatConvey@discussions.microsoft.com> wrote: > Thanks Bob. > [quoted text clipped - 20 lines] >> sure they are current, check that the print quality is set to highest, >> and/or try with another printer. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.