| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding a row when a cell has a value
Hi all,
I would like to hide a row when an option is ticked/unticked. For example; if(a1="x", row20=shown, row20=hidden) Thanks for any help, Souljacked |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding a row when a cell has a value
You can use a worksheet_change event macro to do this. More info.. -- Don Guillett Microsoft MVP Excel SalesAid Software "Souljacked" wrote in message ... Hi all, I would like to hide a row when an option is ticked/unticked. For example; if(a1="x", row20=shown, row20=hidden) Thanks for any help, Souljacked |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding a cell with a formula. | Excel Worksheet Functions | |||
| Hiding a jpeg in a cell? | Excel Discussion (Misc queries) | |||
| Hiding cell information | Excel Worksheet Functions | |||
| hiding 1 cell | Excel Discussion (Misc queries) | |||
| Hiding the value of a formula if 1 cell has a value of zero. | Excel Discussion (Misc queries) | |||
Linear Mode
