Dim szSheet
With ActiveWorkbook.Worksheets("Sheet2")
szSheet = .Visible
.Visible = xlSheetVisible
.PrintPreview
.Visible = szSheet
End With


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Glenn" wrote in message
...
I was give the following to make a button to print a sheet. But how do i
make this macro to print a hidden sheet?
I really do appreciate everyone's help
GlennHi Glenn
--------------------------------------------------------------------------
-
Identify the specific sheet you want to print in the code.....

Sub PrintSpecificSheet()
ActiveWorkbook.Sheets("Sheet2").PrintOut
End Sub
--

-----
XL2003
Regards

William




"Glenn" wrote in message
...
I am a novice learning....
I would like to know how I can write a macro that would make a
particular
worksheet print. I would like to press a button on one sheet and make
another sheet print.
Thanks for your help,
Glenn