In the before print event, I need code to execute only for a particula
worksheet named "Checks" (code name Sheet2). I have tried th
following as well as variations but can't get the if statement to wor
properly:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Active.Worksheets.Name = "Checks" Then
(code goes here)
Else
(other code goes here)
End If
End Sub

I'm trying to keep it simple. Any ideas? Thanks so very much
mikebur

--
mikebur
-----------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458
View this thread: http://www.excelforum.com/showthread.php?threadid=46635