Hi Excel Gurus,
I would like some help again. My workbook automatically loads a macro upon startup but access to a specific sheet (called summary) is only granted to the treasurer by way of a password.
When the treasurer hits the "view Summary" button a userform (containing OK, Cancel buttons, a text box and a label) pops up prompting him to enter his password in the textbox. The reason I went this way is because I want to mask the password. I want when he enters a password and click OK or <Enter> he would be granted access to the sheet, otherwise he would be prompted again to "Enter password). If someone could assist with the code for this I would really appreciate it. I browsed through the Daniel Klann code but that is way too complicated for me.
I would like some help again. My workbook automatically loads a macro upon startup but access to a specific sheet (called summary) is only granted to the treasurer by way of a password.
When the treasurer hits the "view Summary" button a userform (containing OK, Cancel buttons, a text box and a label) pops up prompting him to enter his password in the textbox. The reason I went this way is because I want to mask the password. I want when he enters a password and click OK or <Enter> he would be granted access to the sheet, otherwise he would be prompted again to "Enter password). If someone could assist with the code for this I would really appreciate it. I browsed through the Daniel Klann code but that is way too complicated for me.