gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
Code:
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")