Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing a Sheet (Excel 97)

    I have a workbook with 2 sheets. I want to hide the sheet 2 upon opening the workbook. I have a button on Sheet 1 that I want to click and print sheet 2 and then hide it again. I can't seem to make the code work to do this. Any ideas?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing a Sheet (Excel 97)

    Try this:

    <pre>Public Sub PrintSheet2()
    Application.ScreenUpdating = False
    Worksheets("Sheet2").Visible = True
    Worksheets("Sheet2").PrintOut
    Worksheets("Sheet2").Visible = False
    Application.ScreenUpdating = True
    End Sub
    </pre>

    Legare Coleman

Posting Permissions

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