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

"Ravi Kumar" skrev i meddelelsen
...
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

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
---------------
Jacob Skaria

"Ravi Kumar" wrote:

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