Printout only visbile sheet in Array

[jamesmcintyre]

Hello, i am trying to run a macro that print an array of sheets in the description. However i have a macro that hides certain sheets pending other options and when i do the printout option it comes up with an error if one of the ****s has been hidden. The sheets need to remain hidden depending on the options.

The code i currently have is below.

Sub PrintSpecificSheets()
ThisWorkbook.Worksheets(Array("D 30%", "EW 30%", "RW 30%", "S 30%", "W 30%")).PrintOut
End Sub

Is there an option i can include that only prints the visible sheets out of whats included in the above array?

 

[Jimmypop]

The code above only exports to a pdf and does not print out anything...so not sure what you mean?

 

[jamesmcintyre]

I mean the exported pdf when one of the sheets isnt visible includes all the sheets in the workbook. Not just the ones in the array that are visible.

 

[Jimmypop]

When i tested on my side I did it with all five sheets first and all five where exported, I then proceeded to hide one of the sheets and only 4 exported, I then hid another one and only 3 sheets exported ....

Are you saying that on your side if a sheet is hidden it still exports and shows in the pdf file?

 

[jamesmcintyre]

It is PDFing all sheets in the workbook not just the array even if all are visible in the array.

 

[Jimmypop]

Not sure why... Would suggest starting a new thread to assist with this