Forum Discussion

Copper Contributor

Oct 12, 2023

warning message before i leave a sheet

I want excel to give a prompt message whenever i am leaving a sheet in a workbook, like "Did you update Cell A4"

Gold Contributor

Oct 12, 2023

Private Sub Worksheet_Deactivate()
    MsgBox ("Did you update Cell A4")
End Sub

You can apply this code. In this example the code is in table14 (Tabelle14 in the screenshot).