If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
share a workbook and limit some users
I have a excel spread sheet I use to track property I have purchased and
sold. Due to how fast I buy and sell I need people in my office to have access to enter data on this spread sheet. I want my employees to be able to access this spread sheet but not be able to see all of the columns. I want them only to be able to enter and see the purchase information (Columns A thru J) but not be able to see or edit the sales information (Columns K thru N). 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. --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
share a workbook and limit some users
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 |
#3
|
|||
|
|||
share a workbook and limit some users
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. "kjgarch " wrote in message ... I have a excel spread sheet I use to track property I have purchased and sold. Due to how fast I buy and sell I need people in my office to have access to enter data on this spread sheet. I want my employees to be able to access this spread sheet but not be able to see all of the columns. I want them only to be able to enter and see the purchase information (Columns A thru J) but not be able to see or edit the sales information (Columns K thru N). 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. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|