Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Hide and protect a sheet
Message
De
22/12/2021 16:07:33
 
 
À
22/12/2021 16:00:22
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
01683055
Message ID:
01683063
Vues:
27
>You can get some ideas from Googling [excel password protect single sheet].
>
>Depending on your use case you might be able to have 2 different versions of the whole workbook: one with the hidden page either not accessible at all or not present, and the other with the page visible and accessible.

Thanks, I am trying to avoid dealing with three documents. As you may know, some of the sheets are not for everyone. Excel provides a one click option to hide a sheet. It doesn't have password support at that level. So, if we apply a password at the workbook level, it is for all sheets. For as long as the password is not entered, right clicking on a sheet will not provide an Unhide ability. After the password is entered, we need to unhide one by one. So, there are a few complications. When it gets to that level, people usually move away. I thought that sheet group level hide/password would be nice to have. In reverse, one option would unhide everything for a specific group. VBA can do some of that. But, again, if it gets to that level, this would simply irritate people.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform