Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Hide and protect a sheet
Message
De
22/12/2021 16:00:22
 
 
À
22/12/2021 11:34:43
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
01683055
Message ID:
01683062
Vues:
29
>Excel allows to hide a sheet. Then, we can click on any sheet and select Unhide to make that previous sheet visible again. What I need to do is password protect the unhide functionality. What would be the best practive to achieve that?

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.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform