Question Locked

security

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by absolutely

You'll accomplish a lot more in the not-so-long "long run", and look better doing so.

This discussion is closed to new replies.