Help me in printing a hiden sheet

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
 
P

Per Jessen

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Print hidden sheets 2
selecting workbook/sheet 3
Convert A1 value to a sheet name and copy to it 2
Hiding a column if a cell has an X 1
Macro beginner help with making tables 1
Workbook_BeforeSave 8
VBA-User says active cell jumps to a different sheet upon Save. Please review my code 1

Top