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
|
|||
|
|||
cell protection
how do i stop some one from changing a formula in a
specific cell |
#2
|
|||
|
|||
cell protection
hi,
goto the cell, use Format/Cells/Protection ensure that the cell has locked ticked. Goto Tools/protection/protect sheet. supply a password if you need to and if you have later versions of excel you can specify some options. You will also need to UNLOCK the cells you want the user tobe able to use. Steve -----Original Message----- how do i stop some one from changing a formula in a specific cell . |
Thread Tools | |
Display Modes | |
|
|