Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid any input from user
Without protecting sheet, is there any way to avoid
any input for a particular cell? I tried with the validation ,but I can still copy and paste on the cell. I want to use this cell just for display SK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid any input from user
if you want to use vba you can use the worksheetselectionchange event
and everytime that cell is selected, move to another one before the user can take an action -- When you lose your mind, you free your life. Ever Notice how we use '' for comments in our posts even if they aren''t expected to go into the code? "Shinya Koizumi" wrote: Without protecting sheet, is there any way to avoid any input for a particular cell? I tried with the validation ,but I can still copy and paste on the cell. I want to use this cell just for display SK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid any input from user
Hi sk
You can put macro code in the change event that changes this cell back to what you want. Macros needs to be enabled though and you'll have to write pretty good code. HTH. Best wishes Harald "Shinya Koizumi" skrev i melding ... Without protecting sheet, is there any way to avoid any input for a particular cell? I tried with the validation ,but I can still copy and paste on the cell. I want to use this cell just for display SK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to avoid duplicate string value input in one column? | Excel Worksheet Functions | |||
Protection password iin VBA, how to avoid user seeing it? | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How can I avoid circular reference AND extra input | New Users to Excel | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |