VBA code for printing worksheets that are hidden from a selection

[SteveBreslin]

Hello

I wonder if someone can help me, i have a workbook with various pages that are all hidden except the main page, on the main page it allows users to select items froms drop down boxes that returns a figure to cell B7 on the selection page.

What i would like to do is press a command button and the hidden worksheet that relates to that figure in cell B7 opens which allows the users to print it then after printing or closing the workbook is hidden again.

Many thanks

 

[Andrew Poulsom]

Does this work for you?

Private Sub CommandButton1_Click()
    Application.ScreenUpdating = False
    With Worksheets(Range("B7").Value)
        .Visible = True
        .PrintOut
        .Visible = False
    End With
    Application.ScreenUpdating = True
End Sub

 

[SteveBreslin]

I will try it and let you know many thanks

 

[SteveBreslin]

Thankyou worked well

 

[SteveBreslin]

Sorry to be a pain but could that code work on the value in two cells ie B7 and B6, B7 would open one hidden sheet and B6 would open another hidden sheet at the same time

Many thanks