How to make a range of Cells / rows Visible or Invisible basis 1 input value

**Siddps** · 08-03-2012, 05:49 PM

Hi,

I am looking for an Excel Macro code which can activate a section of worksheet and make it visible for editing basis an input selected on 1 cell. With the changes in the input selection, different range should get activated and be visible.
E.g.
Step 1 - Input / choose option from cell A2 - Options being - 1. Completed 2. Pending (chosen from a Drop down list - Data validation)
Step 2 - Basis Option 1 chosen, Cells A14:I45 becomes visible for the user to input data. Input is completed, data is saved by user.
Step 3 - Option 2 is chosen, cells A50:I90 becomes visible for input.

Till any of the options not chosen, A14:I90 are invisible.

Kindly help me in writing the Macro code for the same.

Thanks much for your help.

**xladept** · 08-05-2012, 08:58 PM

Hi Siddps,

Here's a little code like you describe - it could be put into the Worksheet_Change event, targeting on "A2":

Sub HideSome()
Rows("14:90").Hidden = True
If Range("A2") = 1 Then _
Rows("14:45").Hidden = False
If Range("A2") = 2 Then _
Rows("50:90").Hidden = False
End Sub