ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Don't allow certain people to view worksheets (https://www.excelbanter.com/setting-up-configuration-excel/28629-dont-allow-certain-people-view-worksheets.html)

Dan Connors

Don't allow certain people to view worksheets
 
How can I make it so different worksheets in a workbook can only be accessed
by certain people. Can you set security where somebody can't even SEE the
information unelss you know the password?

Dave Peterson

I don't think you can.

Excel's security isn't that difficult to break or avoid. If you have data that
shouldn't be seen by others, don't share it (or don't share it in excel).

Dan Connors wrote:

How can I make it so different worksheets in a workbook can only be accessed
by certain people. Can you set security where somebody can't even SEE the
information unelss you know the password?


--

Dave Peterson

Dan Connors

That is what I figured...This is more like an Access project

"Dave Peterson" wrote:

I don't think you can.

Excel's security isn't that difficult to break or avoid. If you have data that
shouldn't be seen by others, don't share it (or don't share it in excel).

Dan Connors wrote:

How can I make it so different worksheets in a workbook can only be accessed
by certain people. Can you set security where somebody can't even SEE the
information unelss you know the password?


--

Dave Peterson



All times are GMT +1. The time now is 01:54 AM.

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