Go back to Sheet after message box

[gheyman]

Private Sub Worksheet_Deactivate()

   If Range("B1").Value > 5 Then MsgBox "ERROR: There are estimated hours and/or dollars agains a ""Parent"" WBS level."

End Sub

If this results in True and the message box pops up, can I make it so the code brings the user back to the sheet they deactivated? Sheets("Basis of Estimates")

 

[Fluff]

Like this

Private Sub Worksheet_Deactivate()

   If Range("B1").Value > 5 Then
      Me.Activate
      MsgBox "ERROR: There are estimated hours and/or dollars agains a ""Parent"" WBS level."
   End If

End Sub

 

[gheyman]

Thanks!!!

 

[Fluff]

You welcome