Hello!
I'm fairly new to VBA and have a question, something probably quite simple to fix 
I am trying to work a simple Macro which looks at the item selected on a dropdown (through data validation) for acceptance of Terms and Conditions. If agreed, I want to unhide another tab, if disagree selected, then an error message should be shown and the tab should not be unhidden.
I have managed to get the error message for disagree, however it still unhides the tab
any advice here will be greatly appreciated.
Private Sub Worksheet_Change(ByVal Target As Range)
If (Range("B29") = "Agree") Then
Sub unhide()
'
' unhide Macro
'
'
Sheets("Pricing Conditions").Select
Sheets("Pricing Template").Visible = True
Range("E17").Select
If (Range("B29") <> "Agree") Then
Errormsg:
MsgBox "Please Read Conditions and Agree"
Exit Sub
End If
End Sub
Many thanks,
Mez
Bookmarks