The photo attached will explain thing better. Please have a look.
After I select the visible option to xlSheetVisible, a message is popped up.
I had google for the solution to solve this. But all also fail. I am not Excel expert, but this information hidden is very valuable for me.
Any input is welcome.
Is the workbook protected?
Be as you wish to seem
Originally Posted by Aflatoon
Yes, the workbook is protected. I had unblock the password by some code. But still cannot unblock this
Does the Workbook and the Worksheet have a password and have you got 1 sheet visible ?
It is password protected. But I don't know what's the password.
Please refer to the attached for what I'm talking about.
Now you can d/l a Brute Force password cracker, (well you could about 15 years ago), but I suggest that you make a separate copy of your workbook before doing this because it can mess the workbook up. As well, I have to suggest that you do not do it because a lot of these apps have backdoor allowances coded into them.
“All right now ya wise guy … Dance!”
If both the workbook and the sheets contain passwords and you don't know them then we do not break passwords
Please read the Forum rules !
Posting Permissions
Reply With Quote
