Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Guys,
need your help to disable some cells. i.e. in cell A5, A6, A7, A8, till A15... scenario: 1. If i write Yes in cell A5, then A6-A10 has enable and for A11-A15 has disable, but 2. If i write No in cell A5, then cell A6-A10 has disable and for A11-A15 has enable for writing. and for this scenario, i will very grateful if you give me a way, if i write No in cell A5, then directly go to A11, and skip Cell A6-A10. can you tell me how to do that? so many thanks for your help reza |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable cell focus | Excel Discussion (Misc queries) | |||
Disable cell reference insertion with PageUp in cell edit mode. | Excel Discussion (Misc queries) | |||
Is there a way to disable a macro based on the value of a cell? | Excel Discussion (Misc queries) | |||
Code to disable a cell in excel | Excel Discussion (Misc queries) | |||
disable cell | Excel Discussion (Misc queries) |