Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protected Cell
I have an input sheet that user input data and it calculates a sales price.
I have locked the worksheet and uprotected the cells where the user needs to input information. My question, is there a way that makes it only possible for the user to have access to the unlocked cells. In other words, when the user inputs info into a certain cell, the cursors jumps to the next unlocked cell. Basically I just want to give them access to the unlocked cells. |
#2
|
|||
|
|||
DME, you can tab between the unlocked cells, if you want to have the cursors
jump automatically you will need a macro, something like this right click on the sheet tab and view code, paste this in the window that opens, change to the cells you need Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Range("B6").Select If Target.Address = "$B$6" Then Range("C1").Select If Target.Address = "$C$1" Then Range("A1").Select End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "DME" <craigjoseathotmaildotcom wrote in message ... I have an input sheet that user input data and it calculates a sales price. I have locked the worksheet and uprotected the cells where the user needs to input information. My question, is there a way that makes it only possible for the user to have access to the unlocked cells. In other words, when the user inputs info into a certain cell, the cursors jumps to the next unlocked cell. Basically I just want to give them access to the unlocked cells. |
#3
|
|||
|
|||
Perhaps this will help, I was in help and found:
Give specific users access to protected ranges You must have Windows 2000 to give specific users access to ranges. 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.) Click New. In the Title box, type a title for the range you're granting access to. In the Refers to cells box, type an equal sign (=), and then type a reference or select the range. 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. Click Permissions, and then click Add. 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. Click OK twice, and if prompted retype the password. Repeat the previous steps for each range for which you're granting access. 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. Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges dialog box. 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 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. "DME" wrote: I have an input sheet that user input data and it calculates a sales price. I have locked the worksheet and uprotected the cells where the user needs to input information. My question, is there a way that makes it only possible for the user to have access to the unlocked cells. In other words, when the user inputs info into a certain cell, the cursors jumps to the next unlocked cell. Basically I just want to give them access to the unlocked cells. |
#4
|
|||
|
|||
Tracy-
I am using Excel 2000 and I do not get the feature when I point to Protection. "Tracy B" wrote in message ... Perhaps this will help, I was in help and found: Give specific users access to protected ranges You must have Windows 2000 to give specific users access to ranges. 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.) Click New. In the Title box, type a title for the range you're granting access to. In the Refers to cells box, type an equal sign (=), and then type a reference or select the range. 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. Click Permissions, and then click Add. 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. Click OK twice, and if prompted retype the password. Repeat the previous steps for each range for which you're granting access. 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. Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges dialog box. 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 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. "DME" wrote: I have an input sheet that user input data and it calculates a sales price. I have locked the worksheet and uprotected the cells where the user needs to input information. My question, is there a way that makes it only possible for the user to have access to the unlocked cells. In other words, when the user inputs info into a certain cell, the cursors jumps to the next unlocked cell. Basically I just want to give them access to the unlocked cells. |
#5
|
|||
|
|||
That feature started with Excel 2002.
For methods of Tabbing to cells see Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0008.html The event code provided by Paul is also handy. Gord Dibben Excel MVP On Fri, 8 Apr 2005 11:16:38 -0500, "DME" <craigjoseathotmaildotcom wrote: Tracy- I am using Excel 2000 and I do not get the feature when I point to Protection. "Tracy B" wrote in message ... Perhaps this will help, I was in help and found: Give specific users access to protected ranges You must have Windows 2000 to give specific users access to ranges. 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.) Click New. In the Title box, type a title for the range you're granting access to. In the Refers to cells box, type an equal sign (=), and then type a reference or select the range. 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. Click Permissions, and then click Add. 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. Click OK twice, and if prompted retype the password. Repeat the previous steps for each range for which you're granting access. 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. Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges dialog box. 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 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. "DME" wrote: I have an input sheet that user input data and it calculates a sales price. I have locked the worksheet and uprotected the cells where the user needs to input information. My question, is there a way that makes it only possible for the user to have access to the unlocked cells. In other words, when the user inputs info into a certain cell, the cursors jumps to the next unlocked cell. Basically I just want to give them access to the unlocked cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
CELL PROTECTED IN 2000, UNPROTECTED IN 2003 | Excel Worksheet Functions | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |