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

Print hidden sheets 2
Printing a hiden excel sheet 1
SEARCHING A WORKBOOK ! ! 2
Make the same titles repeated in multiple sheets of a workbook 1
Stop sheet showing when Using Datapig's Force Users to enable macr 1
Rows columns to repeat while printing in a workbook 1
How to restrict printing certain sheets 2
Need to Speed Up A Macro 2

Top