VBA code that Unhide sheet that are hidden using (xlSheetHidden)

[Jamieloool]

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. :yes

Any input is welcome.

[Aflatoon]

Is the workbook protected?

[Jamieloool]

Is the workbook protected?



Yes, the workbook is protected. I had unblock the password by some code. But still cannot unblock this

[Rob342]

Does the Workbook and the Worksheet have a password and have you got 1 sheet visible ?

[Jamieloool]

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.

[Daxton A.]

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.

[Rob342]

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 !