1) are you sure you DON'T have all the apostrophes in the beginning of
each line? my advise would be to remove them

2) you miss "End If" statement after
'ElseIf .Value = "Master Agreement" Then
' Rows(32).Hidden = True
' Rows(33).Hidden = False

at least this is what i have noticed