ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   access to a workbook per userlevel (https://www.excelbanter.com/setting-up-configuration-excel/233148-access-workbook-per-userlevel.html)

newbie_010108

access to a workbook per userlevel
 
Hi, wondering if its possible to set a "SHARED" workbook file and have users
access the file according to their user name. for example once the workbook
will open it prompts for a user name and password if username is equal to
"guest" he can only modify col C and D, if the username is equal to
"administrator" he can modify all the fields in the file/do whatever changes
he wants.


All times are GMT +1. The time now is 08:04 AM.

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