Hi,
I have following code that seems only works on excel 2007 but not in excel 2010

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Worksheets(2).Range("E67").Value <> "COMPLETED" Then
    Cancel = True
    MsgBox ("Kui ra iso nge-print, bereskeun heula gawena!!!")
End If
End Sub
What should I do to make it works on excel 2010?

Regards,
saesaria

NB:
cross thread
http://answers.microsoft.com/en-us/o...c-d84a6c8b734f