Cell passwords
 

Can I assign a password to pop up when there is a particular cell selected,
say B6 in order to gain access to that cell for modification? Alll other
cells should be able to be modified, just not that one without a password.

Cell passwords
 

when you're in that cell, you can set up data validation so that no
one can modify it. of course, that means YOU, too, but you will know
how to undo the validation so you can modify it, & then revalidate it.

on the toolbar - data
validation

play around with it & see what you can do.
if you want it to be completely unmodify-able, make the settings:
"custom"
and enter =""
in the formula that is allowed. then you can set up a message that
will show in the error messages, such as

Formula Cell! No manual calculation allowed.

(which is what i use).

when you want to get INTO the cell, call up data validation & clear
all. then you have to redo it (as described above) after you make
your changes.

i got tired of doing this back & forth, myself, so i created a macro
button that automatically sets the validation:


Sub LockFormulaValidation()
'
' LockFormulaValidation Macro
' Macro recorded 8/25/2006 by Susan
'
With Selection.Validation
.Delete
.Add Type:=xlValidateCustom, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="="""""
.IgnoreBlank = False
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = "FORMULA CELL"
.InputMessage = ""
.ErrorMessage = "No manual calculation allowed!"
.ShowInput = False
.ShowError = True
End With
End Sub


too much help? :)
susan

On Apr 18, 2:04 pm, newguyA14
wrote:
Can I assign a password to pop up when there is a particular cell selected,
say B6 in order to gain access to that cell for modification? Alll other
cells should be able to be modified, just not that one without a password.

Cell passwords
 

Check out the edit range functionality, you can set passwords for specific
cells or ranges while maintaining protection on the rest of the sheet.
TOOLSPROTECTIONALLOW USERS TO EDIT RANGE
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"newguyA14" wrote:

Can I assign a password to pop up when there is a particular cell selected,
say B6 in order to gain access to that cell for modification? Alll other
cells should be able to be modified, just not that one without a password.

Cell passwords
 

Thanks for the help, that works great!

"newguyA14" wrote:

Can I assign a password to pop up when there is a particular cell selected,
say B6 in order to gain access to that cell for modification? Alll other
cells should be able to be modified, just not that one without a password.