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
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