Disabling Tabs (REALLY disable)

[PrimePorkchop]

I know about hiding the tabs under "Advanced Options" but anyone who comes along behind me that knows how to, can reverse that. I tried "locking" the workbook, but it still doesn't remove the option.

Any creative solutions for this that you're aware of? I don't want people being able to "unhide" tabs, I want access to certain tabs locked down to only be accessible with a password (ill use a userform for the password)

[alansidman]

https://docs.microsoft.com/en-us/off...e-xlveryhidden

and then lock down your VBA with a password.

[6StringJazzer]

What option under "Advanced Options" has to do with hiding tabs?

If you lock the workbook with a password and check Structure then hidden sheets cannot be unhidden by a user.

Another possibility is to go into the VBA window, which you probably know how to do since you are talking about creating a UserForm, and set the visibility of a sheet to VeryHidden. This means that a user cannot even see that the sheet exists. But then you will have to put a password on the VBA.

I don't know why you need to hide this sheet but please be aware that any of the above are not very secure, and neither is your method of using a password from a UserForm. These methods will discourage a compliant user but not a motivated malicious user. If you have a bona fide security issue you will need to use something not built into Excel.

There are also Excel "compilers" that may add a measure of security but I can't vouch for it.

[TMS]

To add to Alan's suggestion, you really need to lock and hide formulae on the visible sheets and protect them with a password so that users can't intuit that there are other sheets.

And then you need to protect your VBA Project with a password so they can't see the structure under the covers.

[TMS]

@6SJ: I’m not a "motivated malicious user" but I do tend to be intrigued by what's under the covers and would invariably pry the bonnet up

[hrlngrv]

VBA code in ONE workbook can be used to attack protections in OTHER workbooks. Password protected VBA projects don't protect the whole workbook.

Also, it just ain't that difficult to defeat ALL internal protections in Excel workbooks. I'm not going to go into how-to, just going to say that file-open passwords are the only robust security Excel provides. Everything else is only effective against innocent curiosity. Best to keep that in mind when deciding what should go into Excel workbooks, and who should be able to open those Excel workbooks.

[TMS]

... I'm not going to go into how-to ...

l think you probably just did, or at least gave a big hint

[PrimePorkchop]

I'm not worried about a malicious user - just more a curious wanderer... I'm aware if someone WANTS to get in, they will, but as with most things, curiosity will end up creating more work for me, as people "poke around" and screw things up.

xlVeryHidden & password protecting VBA seems to be exactly what I'm looking for - thank you all for the feedback!

[TMS]

I fear that, with all things Excel, ...

people "poke around" and screw things up.