pops up message when run the userform if specific sheet is hidden

[KalilMe]

hello

I have many sheets are hidden except sheet MAIN to run userform from of it . when I run the userform and the sheet DATA is hidden , then should pops up messge " threre is missed data" and close the userform , and if the sheet DATA is not hidden when run the userform should keep showing .
and if try up to 3 times and three times shows the message then should pops up message" sorry run out your tries" and close the file

thanks

 

[KalilMe]

even the sheet data is not hidden .it continues showing message

 

[Micron]

perhaps

Private Sub UserForm_Initialize()

If FormShowCount >= 2 Then
     MsgBox "You have reached the maximum tries allowed." & vbCrLf & vbCrLf & "Workbook will now close."
     ThisWorkbook.Close
     Exit Sub
End If

If Sheets("DATA").Visible = False Then
     MsgBox "Cannot proceed if Data sheet is hidden"
     Unload Me
Else
     FormShowCount = 0
     Exit Sub
End If

FormShowCount = FormShowCount + 1

End Sub

 

[KalilMe]

fantastic ! it works excellently
much appreciated for your following my thread & solving

 

[Micron]

Wheww! Good, because that's all I've got left in me for this one!