Question
June 24, 2007 at 10:13 AM
aiai_tan75

security

by aiai_tan75 . Updated 19 years, 4 months ago

im currently trying to reduce paperwork and the number of workbooks for our small company. is it possible to have one worksheet with all information on it such as job orders, invoices, customer information but not all columns are visible to certain users?

e.g. workbook A contains all data

but user 1 can view and edit columns 1-5
user 2 can only view and edit columns 1-4
user 3 can view columns 1-4 but can only edit column 3

im hoping this could be done by assigning passwords for each column as i am not very tech savvy and know nothing about networking,database and the like

would appreciate any help

This discussion is locked

All Comments