Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another cell protection question
I have a spreadsheet I need to protect in a unique way. I have cells that
have conditional formatting that works like this: Cells in column D have a drop down menu. When SOLD is selected from Cell D4, the entire row 4 changes color to Red. If SALE PENDING is selected, the entire row turns yellow. Other cells in the row require input but some people have chosen to copy and paste one cell to another totally messing up the conditional formatting. I want to allow data entry but I want to prevent cut/copy/paste in the worksheet. Is there a way to protect a cell so that it can have data entered into it but not cut/pasted in or out of? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another cell protection question
Hi,
Give specific users access to protected ranges In order to give specific users access to ranges, your computer must be running Windows 2000 or later and it must be on a domain. 1. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges. (This command is available only when the worksheet is not protected.) 2. Click New. 3. In the Title box, type a title for the range you're granting access to. 4. In the Refers to cells box, type an equal sign (=), and then type a reference or select the range. 5. In the Range password box, type a password to access the range. The password is optional; if you don't supply a password, any user will be able to edit the cells. 6. Click Permissions, and then click Add. 7. Locate and select the users to whom you want to grant access. If you want to select multiple users, hold down CTRL while you click the names. 8. Click OK twice. If prompted, retype the password. 9. Repeat the previous steps for each range for which you're granting access. 10. To retain a separate record of the ranges and users, select the Paste permissions information into a new workbook check box in the Allow Users to Edit Ranges dialog box. 11. Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges dialog box. 12. In the Protect Sheet dialog box, make sure the Protect worksheet and contents of locked cells check box is selected, type a password for the worksheet, click OK, and then retype the password to confirm. Note: A sheet password is required to prevent other users from being able to edit your designated ranges. Make sure you choose a password you can remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet. Challa Prabhu "brodiemac" wrote: I have a spreadsheet I need to protect in a unique way. I have cells that have conditional formatting that works like this: Cells in column D have a drop down menu. When SOLD is selected from Cell D4, the entire row 4 changes color to Red. If SALE PENDING is selected, the entire row turns yellow. Other cells in the row require input but some people have chosen to copy and paste one cell to another totally messing up the conditional formatting. I want to allow data entry but I want to prevent cut/copy/paste in the worksheet. Is there a way to protect a cell so that it can have data entered into it but not cut/pasted in or out of? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A Worksheet Protection Question | New Users to Excel | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
newbie protection question | New Users to Excel | |||
Excel Booklet Protection Question | Excel Worksheet Functions | |||
question about excel protection tool | Excel Discussion (Misc queries) |