Printing Hidden Sheets

[Shazz]

Hi,

I have a dashboard which I have various buttons on, I want to be able to have a button to print particular hidden sheets, I have set up a macro but this prints the dashboard as well as the hidden sheet.

The sheet I want to print is called "Start Dates" anyone have any suggestions.

Shazz
xx

 

[Deepak]

As you haven't shared the code then you would try something like below.

Sub printWS()
With Sheets("Start Dates")
    .Visible = -1
    .PrintOut
    .Visible = 2
End With
End Sub

 

[Shazz]

Sorry the code that comes up when I create the macro is below.

Sub Print_StartDates()
'
' Print_StartDates Macro
'

'
    Sheets("Dashboard").Select
    Sheets("Start Dates").Visible = True
    ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

 

[Shazz]

I fort to say that the code you gave below did not work.

Sub printWS()
With Sheets("Start Dates")
    .Visible = -1
    .PrintOut
    .Visible = 2
End With
End Sub

 

[Luke M]

Can you elaborate on what "did not work" means? Did the code error out, did nothing happen, did the wrong sheet print out?

 

[Shazz]

I'm really sorry, I had not actually attached the macro properly.

It works a treat, thanks so much.