Printing from very hidden excel sheets

[dss28]

In my workbook, I have several sheets which contain different forms and where the data is populated through vba program.
I am able to print these forms only when the sheets are made visible, if very hidden the printing is not possible.
I am adding thisworkbook.sheets("sheetname").activate command in each printing code but not working with veryhidden sheets.

any suggestions please to print from veryhidden sheets.

 

[RoryA]

You have to unhide them first by setting the visible property to xlsheetvisible

 

[dss28]

thanks for the same. however when I use the below code, the hidden sheet is displayed at the back of the userform which looks unprofessional.
can you suggest better way / refined way in the coding.

Sheet "PrintReport" is veryhidden, I use a userform67 to transfer data from two textboxes to sheet "PrintReport" and then call a code to gather other data from master sheet using vlookup.

Private Sub CommandButton1_Click() 


On Error Resume Next
' Application.ScreenUpdating = False

  ThisWorkbook.Sheets("PrintReport").Visible = xlSheetVisible   
 ThisWorkbook.Sheets("PrintReport").Activate

With Sheet14               


.Range("D11:P16") = ""           
.Range("O8") = ""
.Range("K8") = ""
.Range("F18") = ""

.Range("D36:P41") = ""   
.Range("O33") = ""
.Range("F43") = ""
  
          
        ThisWorkbook.Sheets("PrintReport").Range("O8").Value = UserForm67.TextBox1.Text           

        ThisWorkbook.Sheets("PrintReport").Range("K8").Value = UserForm67.TextBox2.Text           
        
 
    Call OfflinePrint     ‘ code to transfer data from master data sheet to sheet14 for printing
 
   ThisWorkbook.Sheets("PrintReport").Visible = False
  
 
       Unload UserForm67

 On Error Resume Next
 
    Application.Dialogs(xlDialogPrinterSetup).Show
    
    ActiveSheet.PrintOut       
  
        End With
        
        ThisWorkbook.Sheets("Welcome").Activate

 
   Application.ScreenUpdating = True
 
 
End Sub

 

[RoryA]

You should be turning off screenupdating

 

[dss28]

thanks a lot