i made a workbook with a userform that make it to run in opening so when i open excel i see the userform instead of worksheet
i decide to put a password to open it but then happened something strange. next that i opened workbook and put the password
i saw the userform. sometime i wanted to close userform and see the worksheet to make some adjustments. i use to do often that cause is in development
but the worksheet wasnt appear neither in windows bar or with alt+tab nothing nowhere. and ofcourse i couldn't run again the userform so i closed from task manager cause excel was still running. after i open another excel deactivate macros and reopen my workbook and was all good except it hadnt load userform cause macros was deactivated so i unportected the password and after i activate again macros and then all normal. why is happenng this ? how to encrypt with password?