Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell passwords | Excel Discussion (Misc queries) | |||
Excel control cell display of data with passwords | Excel Worksheet Functions | |||
Passwords | Excel Programming | |||
passwords | Setting up and Configuration of Excel | |||
Passwords | Excel Programming |