share workbook and limit access to users

K

kjgarch

I have a excel spread sheet I use to track property I have purchased an
sold. Due to how fast I buy and sell I need people in my office t
have access to enter data on this spread sheet. I want my employees t
be able to access this spread sheet but not be able to see all of th
columns. I want them only to be able to enter and see the purchas
information (Columns A thru J) but not be able to see or edit the sale
information (Columns K thru N).

What I would like is to have one sheet that more than one user coul
use, but only let myself be able to see sales information (Cloumns
thru N). It would be nice if everyone had there own password and onl
my password would allow for all information to be visible. Could yo
give me detailed instructions on how to make this happen. Let me tel
you I am not an experienced Excel user, therefore will need ver
detailed directions to follow
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
share a workbook and limit some users 2
Locking Pages and/or Workbook 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Converting Letters To Numbers Summary??? 2
Using Access Database to build contracts with fields on pdf document 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0

Top