Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi DB,
You must unhide it before you can print it. To prevent the worksheet from becoming visible, use Application.ScreenUpdating = False. I got the following Sub from another thread: ========================= Public Sub printHiddenWs(ByVal ws As Excel.Worksheet) Dim hidden As Long With ws .Application.ScreenUpdating = False hidden = .Visible .PrintOut .Visible = hidden .Application.ScreenUpdating = True End With End Sub ========================= Regards, Steve www.stkomp.com wrote: I am having a user input some info. The info gets tested, another hidden form gets the data applied to the proper cells and then printed. Q1 How can I print the correctly filled sheet without making it visible? Q2 Will I have to create another instance of excel to do this? How can I create the other instance and keep it hidden? etc... Tks DB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent printing a sheet | Excel Discussion (Misc queries) | |||
printing only first column, why not all of sheet? | New Users to Excel | |||
Printing a sheet | Excel Programming | |||
Unprotect sheet when printing | Excel Discussion (Misc queries) | |||
Printing Each Sheet | Excel Programming |