ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Password Required to View\edit a Sheet in a Workbook with Many She (https://www.excelbanter.com/excel-discussion-misc-queries/79868-password-required-view%5Cedit-sheet-workbook-many-she.html)

Ed

Password Required to View\edit a Sheet in a Workbook with Many She
 
We have a workbook with 7 worksheets. We want to hid one sheet so that in
can only be viewed if the user has the password. All user must have the
ability to access and edit the other worksheets in the workbook. We want
three users and only three users to have access to a hidden worksheet. We
would prefer not to password protect the workbook.
--
Ed

Dave Peterson

Password Required to View\edit a Sheet in a Workbook with Many She
 
If the information on that worksheet shouldn't be viewed except by the person
with the password, then excel isn't the correct tool for you.

Excel's protection schemes are easily broken and your information will be
available to anyone who is really curious.

Ed wrote:

We have a workbook with 7 worksheets. We want to hid one sheet so that in
can only be viewed if the user has the password. All user must have the
ability to access and edit the other worksheets in the workbook. We want
three users and only three users to have access to a hidden worksheet. We
would prefer not to password protect the workbook.
--
Ed


--

Dave Peterson


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com