Once you've got your answer you can write a macro that will run when the
workbook is saved. Maybe not the most succinct method, but the only one
I know:
In 'ThisWorkbook' write:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If Cells(y1,6).value = "yes" then
If Cells(y2,5).value = "" then
MsgBox("Please enter value in cell y2,5)
Cancel = True
End If
End If
End Sub
where y1 and y2 are the relevant rows.
--
PipTT
------------------------------------------------------------------------
PipTT's Profile:
http://www.excelforum.com/member.php...o&userid=30989
View this thread:
http://www.excelforum.com/showthread...hreadid=506582