+ Reply to Thread
Results 1 to 2 of 2

Hidden rows are printing as blank pages...

Hybrid View

  1. #1
    Registered User
    Join Date
    03-15-2012
    Location
    Shreveport, LA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Hidden rows are printing as blank pages...

    I apologize if there are other posts regarding this topic however, none have given the solution to this or I just haven't found it.

    I have a worksheet that I have created page breaks in so as to separate the documents on this sheet. The page breaks are important and can not be changed so print selection is not an option. I have check boxes that allow rows to become visible if that document is to be used. If the check box is not marked or selected then those rows remain hidden. The problem comes in printing. Because the documents have content on them, they print as blank pages. I am sure it is because of the page breaks. I am very new to writing VBA Code which is what I believe I need to make this work as I need it to. Something along the lines of If certain rows are hidden don't print those pages. If visible, print them.

    Thanks in advance for any assistance that you can offer.

    tprice317

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Hidden rows are printing as blank pages...

    Do you have a sample file with these page breaks set as you want?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1