I've used this macro many times before but in this new workbook, I get the
VB compile error. Here is the code:

************************************************************
Sub DeleteRow()
ActiveSheet.Unprotect 'place at the beginning of the code
MyMsgBox = MsgBox("Are you sure you really want to delete this row??
:oD", vbOKCancel + vbExclamation, "Delete ... ?")

If MyMsgBox = 1 Then

Selection.EntireRow.Delete

End If

ActiveSheet.Protect ' place at end of code
End Sub
************************************************************

In another similar case, it was just a question of adding "Option Explicit"
at the top of the code window. The thing is that this already has that text
there, so I'm stumped. I searched for this error code, but couldn't figure
out the resolution to this particular problem.

Thanks in advance for any help re this. Once this is fixed, I can share the
workbook. :oD