How to hide PW protected tab on the excel sheet

[Altamija]

Edited by FlameRetired Added code tags.

I have below VBA, which PW protecting one of the sheets. What I need to change on my VBA to be able to hide this tab "##"

Please Login or Register  to view this content.

Thank you

[Bernie Deitrick]

The problem with your code is that if the entered response is incorrect, then there is no way to re-select the sheet to re-initiate the PassWord entry. You might want to use code on an always-visible worksheet assigned to a button "Unhide Sheet ##" and use code like

Please Login or Register  to view this content.

You can always use the before close event to fire code to hide any sheet that should be opened using a password.

Please Login or Register  to view this content.

[FlameRetired]

Altamija please read our forum rules regarding code tags.

Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

Since you are relatively new to the forum I went ahead and added them for you.

[Altamija]

Dave ,
I sincerely apologize for this error.

[FlameRetired]

No harm, no foul.

[Altamija]

Thank you Bernie, Combination of this two codes works perfectly !! Thanks again .

[KOKOSEK]

Please Login or Register  to view this content.

If you are using VBA to hide/show sheets, I suggest:

Please Login or Register  to view this content.

FALSE is still visible to 'unhide' under right mouse click, set as 2 does not exist for 'unhide' by right click and can be shown only via VBA.