ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 - security / limiting access (https://www.excelbanter.com/excel-discussion-misc-queries/241431-excel-2007-security-limiting-access.html)

Paul

Excel 2007 - security / limiting access
 
Hi All,

I have a quick question re. Excel 2007.

At the moment, I have a workbook with lots of different worksheets (called
say WS1, WS2, WS3, WS4 etc). The workbook needs to be accessable to lots of
different people, but I would like control which worksheets certain people
can see and edit (e.g. Person A, can only see and edit WS1 and WS4; Person B
limited to WS2 only; Person C can see and edit the whole workbook etc).

Any ideas if this can be done? Any ideas how?

Ideas would be welcome!

Thanks guys,

Paul




All times are GMT +1. The time now is 02:49 PM.

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