VBA help with opening hidden sheets with a password

Hey all. I am new to VBA and am working on a project that now has me obsessed and stressed - until I figure it out.

I have a workbook with several sheets. The main "HOME" sheet has hyperlinks to each sheet.
My question is - how do I hide one sheet "The ADMIN sheet" and still activate it?

I created a userform for the Admin link so the user has to enter a password to access that sheet. It works great - until I hide the sheet. As soon as I do this, the link is broken.

Here is the coding I am using that works when the sheet is visible. What parts do I need to modify so it will still work when the sheet is hidden?
Thank you!

Please Login or Register  to view this content.