ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Restricting Multi-user access (https://www.excelbanter.com/excel-worksheet-functions/31294-restricting-multi-user-access.html)

[email protected]

Restricting Multi-user access
 
I am wondering if it is possible to restrict acces to certain parts of
a spreadsheet depending on the user. Here is my scenario:

We will be 3 users working on the same spreadsheet. User 'a' only
need to be able to write in columns A-E but read the whole
spreadsheet.
User 'b' needs to be able to write in all columns
User 'c' needs to be able to write only in column H and read the whole
spreadsheet.

Is there any possible way to do this with excel through a system of
different passwords OR userID recognition or any other way . ..



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

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