+ Reply to Thread
Results 1 to 8 of 8

Printing hidden sheets

  1. 10-30-2013, 12:23 AM #1
    SperoTsindos
    SperoTsindos is offline
    Registered User
    Join Date
    10-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Printing hidden sheets

    Hello Everyone,
    I am new to the forum, but I have been viewing threads for a while now. I have been working with a large workbook of about 100 worksheets, all bar one are hidden. Each hidden sheet is brought up for entering data and then hidden when the user returns to the main page.
    What I want to be able to do is print preview only certain worksheets and allowing the user to check them for formatting, etc before printing. I have found the following, which works well on a single worksheet, but won't allow multiple sheets. I have tried using "Array", but with no success.
    Please Login or Register  to view this content.
    Any advice would be gratefully accepted.
    Thanks,
    SperoTsindos
    Last edited by SperoTsindos; 10-30-2013 at 11:45 PM. Reason: Correcting the code protocol
    Reply With QuoteRegister To Reply
  2. 10-30-2013, 12:45 AM #2
    BrianM45
    BrianM45 is offline
    Forum Contributor
    Join Date
    05-10-2012
    Location
    Paris, France
    MS-Off Ver
    2016/365
    Posts
    123

    Re: Printing hidden sheets

    Hi SperoTsindos

    Try this code 
    Please Login or Register  to view this content.
    A+
    Reply With QuoteRegister To Reply
  3. 10-30-2013, 05:19 PM #3
    SperoTsindos
    SperoTsindos is offline
    Registered User
    Join Date
    10-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Printing hidden sheets

    Hi BrianM45,
    Many thanks for this code. Unfortunately, despite specifying certain worksheets, it Print Previews everything and what i need is a code that will allow me to list the specific sheets and then when it runs print preview them. Does this coding do that with suitable tweaking?
    Cheers,
    SperoTsindos
    Reply With QuoteRegister To Reply
  4. 10-30-2013, 10:28 PM #4
    BrianM45
    BrianM45 is offline
    Forum Contributor
    Join Date
    05-10-2012
    Location
    Paris, France
    MS-Off Ver
    2016/365
    Posts
    123

    Re: Printing hidden sheets

    Hi,

    Quote Originally Posted by SperoTsindos View Post
    Unfortunately, despite specifying certain worksheets, it Print Previews everything
    I dont understand why, because it work home

    Quote Originally Posted by SperoTsindos View Post
    and what i need is a code that will allow me to list the specific sheets and then when it runs print preview them
    This is what he does

    Quote Originally Posted by SperoTsindos View Post
    Does this coding do that with suitable tweaking?
    Can you paste your actual code ?

    A+
    Reply With QuoteRegister To Reply
  5. 10-30-2013, 10:47 PM #5
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Printing hidden sheets

    Hello SperoTsindos,

    Welcome to the Forum.

    Please take a moment to review the Forum Rules.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    Please go back to your first Post, and click on Edit>highlight your Code, and then click On the # icon.

    Thank you
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  6. 10-30-2013, 11:47 PM #6
    SperoTsindos
    SperoTsindos is offline
    Registered User
    Join Date
    10-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Printing hidden sheets

    Sorry about the protocol problem. I will respond to BrianM45 as soon as I can access the code again.
    Cheers,
    SperoTsindos
    Reply With QuoteRegister To Reply
  7. 10-31-2013, 12:30 AM #7
    SperoTsindos
    SperoTsindos is offline
    Registered User
    Join Date
    10-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Printing hidden sheets

    Hi BrianM45
    This is the code I ran from your original suggestion:
    Please Login or Register  to view this content.
    I substituted your terms after NoPrint= with the names of the sheets i wanted to print.
    The outcome is that all sheets (including the only visible one appear in the Print Preview screen. I want to be able to print the requested sheets as a single document, but it appears as though the code displays each sheet as a separate document. In other words the sheets need to printed collectively as a final report. The majority of hidden sheets are for data entry only with only a few sheets (10 in total) to be available as a final report. I thought that if i can get past the printing of more than one sheet, i can add the other sheets in tandem for a complete report.
    Sorry about this, but this is the last stage of a very long project.
    Cheers,
    Spero.
    Reply With QuoteRegister To Reply
  8. 11-05-2013, 11:55 PM #8
    SperoTsindos
    SperoTsindos is offline
    Registered User
    Join Date
    10-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Re: Printing hidden sheets

    Hi BrianM45,
    I have resolved the issue using simple code. This code allows me to select a number of different sheets, make them visible, gather them all together and activate and then display them in PrintPreview. It also then allows me to scroll through the pages to check them for correctness and then print. Once they are printed, the MACRO hides the sheets again.
    here is the code:
    Please Login or Register  to view this content.
    Many thanks for your assistance.
    Cheers,
    SperoTsindos
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code for printing one of several hidden sheets
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2010, 10:53 AM
  2. hiding sheets but still letting macros run when printing hidden sheets
    By stevesunfold in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 11-13-2008, 04:35 AM
  3. Printing hidden worksheets
    By MarcoR in forum Excel General
    Replies: 4
    Last Post: 04-08-2006, 04:45 PM
  4. Printing a hidden sheet
    By sungen99 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2006, 10:55 AM
  5. Printing hidden worksheets?
    By MichelleDuquette in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2005, 01:06 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1