I have some columns that auto unhide and when this happens, a prompt message displays to inform the user to complete the next level.
However, whenever the user makes another selection, the prompt box keeps coming back up.
How would I only run the message once?
This is the code I am using and I have attached the sheet,
![]()
Private Sub Worksheet_Change(ByVal Target As Range) Columns("C:D").EntireColumn.Hidden = Range("B49").Value < 3 Columns("E:F").EntireColumn.Hidden = Range("D49").Value < 3 If Range("D49").Value = 3 Then MsgBox "Please complete assessment for Mastery Level" ElseIf Range("B49").Value = 3 Then MsgBox "Please complete assessment for Intermediate Level" End If End Sub
Bookmarks