share a workbook and limit some users

[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

 

[Jan Karel Pieterse]

Hi Kjgarch,

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

The safest way to do this is to separate the information you need shared
from the information you need to keep private by putting them in
separate workbooks.
But I would strongly recommend you not to share the workbook in the
first place and consider to use Access for this task. Excel is not
reliable on sharing workbooks. They crash too often and get corrupted
too easy.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Trevor]

Taking the approach that there are 2 kinds of users (you and everyone else)
then I think that simple worksheet protection ought to take care of your
needs.

1. Highlight columns A through J
2. Choose Format menu->Cells item->Protection tab and REMOVE the check from
"Locked" and press OK.
3. Highlight columns K through N
4. Choose Format menu->Column item->Hide item
5. Choose Tools menu->Protection item->Protect Sheet item
6. Enter a password and press OK

Now, everyone can open the spreadsheet and update values in columns A
through J, but they won't be able to see anything in columns K through N
without the password. If you need to see or update those cells, just
unprotect the sheet and then highlight columns J through O and choose
Unhide, so that K through N are visible again.

I hope that serves your need.