[EXCEL] Invisible sheet / password Solved

Question

Hello,

I would like a sheet in my workbook to be visible only when the password for that sheet has been entered.

I know how to lock a sheet so that it cannot be modified without a password, but I would like to go further by preventing a user from seeing its content as well.

How can I do that?

Thank you in advance for your help ;)

Edouard

m@rina · Accepted Answer

Hello,

If it's just a matter of easily hiding and showing a sheet, there's no need for VBA, especially if you're targeting multiple users:

- Format Menu, Sheet => Hide
- Tools, Protection => Protect Workbook (Structure) => Password

To show the sheet =>
- Tools, Protection => Remove Workbook Protection => Password
- Format Menu, Sheet => Show

Workbook protection protects the structure of the workbook, thus preventing the insertion, renaming, deletion, or moving of a sheet. If that's not an issue, it's the simplest solution.

m@rina

gbinforme · Answer

Hello

By going into the properties of the sheet in the VBA editor, set the "visible" property to xlsheetveryhidden after applying your protections.

Don’t forget your passwords because otherwise, you won’t be able to see it either
--

Always stay calm

Eddydiver · Answer

Hello Gbinforme,

Thank you for your response.

However, could you explain the procedure to follow in a little more detail, please?
Indeed, I don't know anything about VBA...

Moreover, does your method allow for easily viewing the hidden sheet after entering a code for another user who is not familiar with VBA and knows little about Excel?

Thank you,

Edouard.

gbinforme · Answer

Hello

To access VBA, here is a manual

When you see the sheet you want to hide, select it and press F4 to open the properties window.

In the last property, "visible," select the code 2 xlsheetveryhidden

Actually, there is nothing in VBA in this procedure; it's just to set the property to very hidden.

Then, to view the sheet, you need to follow the same procedure by setting visible to 1.

It's up to you to decide if it's usable by others or not.
--

Always zen

Eddydiver · Answer

Thank you both for your help.  I used the simplest version of "M@rina". ;)  P.S: if a moderator could add [Resolved] to my message, thank you :)

[EXCEL] Invisible sheet / password

5 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

Code 80072efe how to get windows update working again

Video in ".3gp" format

How to reactivate sms notifications on my galaxy ace?

Limited wifi connection: invalid ip address

Wii sport resort-hidden target

Total av has charged my bank account.