Hide/unhide tabs based on cell value in table VBA

It would be easier to help if we could see what your workbook looks like, including the userform and any macros currently in use. Perhaps you could attach a copy of your file, de-sensitized if necessary.

In addition, are you doing this to prevent people from making mistakes or are you dealing with sensitive data?

I ask because Excel isnt meant to protect sensitive data. If you are doing it as a preventative measure to keep people from goofing things up, ignore the rest of my post.

Sheet protection is a preventative measure to keep people from making mistakes and overwriting formulas etc, its NOT a security feature. It also has no effect on the visibility of a sheet as far as I am aware (so a user could simply unhide a sheet if they want manually). Sheet protection is very easy to circumvent alone. VBA to be honest removes any left over sense of "security" it may have given because you are storing the passwords in the file itself and passing them in plain text. There are numerous ways someone could extract the information and/or credentials or just plain circumvent them completely.

The only "secure" protection Excel offers out of the box is password to open and password to modify. These actually encrypt the file, however they are all or nothing solutions. As soon as someone has a password to open or modify all bets are off and we are back to the root issue, which is Excel isnt meant to securely store data. Worksheet, workbook and even VBA protection are essentially useless as anything more then preventing people who dont care to poke at it from making mistakes.