Printing a hidden sheet in excel

  • Thread starter Thread starter Ron Weaver
  • Start date Start date
R

Ron Weaver

I AM USING THE FORM TOOLS TO CREATE A PRINT DIALOG BOX. IN
THIS BOX I AM HOPING TO PRINT SHEETS IN THIS WORKBOOK. THE
CATCH IS, I WANT TO HIDE THE SHEETS. IS THERE ANY WAY TO
DO THIS? I AM USING OFFICE XP EXCEL.
RON
 
my guess is that you do not want the sheets visible at
all, even while they are printing. the only way is to
unhide the sheet, print it, and then hiding it again.
try this:

sub PrintHiddenSheet
ScreenUpdating = False
Sheets("Sheet1").Visible = True
Sheets("Sheet1").PrintOut
Sheets("Sheet1").Visible = xlVeryHidden
ScreenUpdating = True
End Sub
 
Back
Top