Hi,
I have following code that seems only works on excel 2007 but not in excel 2010
What should I do to make it works on 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
Regards,
saesaria
NB:
cross thread
http://answers.microsoft.com/en-us/o...c-d84a6c8b734f
Bookmarks