• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Password not working as it should

Corrie80405

New Member
Good Afternoon,

I have entered a passwords 12345 to open al sheets but not sheet 2.

The password is not working.

Please advice.

Thanks

Corrie
 

Attachments

  • 77777777.xlsm
    21 KB · Views: 2
Sorry I mean when the password is entered 12345 all the sheets must show. But without the password Sheet 1, 3,4 and 5 only needs to show.
 
Corrie80405
Q: Why there is Workbook_BeforeClose with UserForm-code?
... which has code
... anyway, I would use that code
in ThisWorkbook ... Workbook_BeforeClose ... is empty?

Only Sheet2-sheet seems to try to hide and show
... other sheets
... hmm? ... one-by-one select ... but why?
 
Hi Herofox,

Thank you now it's working but how do I get it to hide the second page if I do not have the correct password in.
 

Attachments

  • 77.xlsm
    21.1 KB · Views: 1
Back
Top