Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hide and protect a sheet
Message
From
22/12/2021 16:07:33
 
 
To
22/12/2021 16:00:22
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
General information
Forum:
Microsoft Office
Category:
Excel
Miscellaneous
Thread ID:
01683055
Message ID:
01683063
Views:
26
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform