Help me in printing a hiden sheet

  • Thread starter Thread starter Ravi Kumar
  • Start date Start date
R

Ravi Kumar

I am trying to distribute a workbook which contains several sheets. The
input is entered in sheet1 and manipulated, reproduced and filled in other
several sheets. However, I do not want my user to access other than sheet1
sheets in order to ensure not disturbing the design and formulas in other
sheets. I want to hide these sheets print them while they are hidden.
Please help
 
Hi the sheets has to be visible to print them. Look at this:

Application.ScreenUpdating = False
With Sheets("Sheet2")
.Visible = True
.PrintOut
.Visible = False
End With
Application.ScreenUpdating = True

Regards,
Per
 
Application.ScreenUpdating = False
ActiveWorkbook.Sheets(2).visible = false

ActiveWorkbook.sheets(2).PrintOut

ActiveWorkbook.Sheets(2).visible = True
Application.ScreenUpdating = True


If this post helps click Yes
 
Back
Top