Hide and unhide row based on cell value

[rintelen]

I have a spreadsheet with a value in GB12 that is either 0 or 1.

When the value of GB12= 0 I want Row 9 to remain or be un-hidden (visible).

But when GB12 = 1 I want row 9 to be hidden.

How can I do this please?

I'm very stupid at excel so you need to walk me through the process of how I can make this macro only apply to this one sheet (the excel sheet has many tabs) so that it updates all the time.

The sheets name is PV Calculator.

 

[Yahya]

right click on sheet name--> view code , then paste this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) <> "GB12" Then Exit Sub
Rows("9").Hidden = Range("GB12").Value = 0
End Sub

 

[Michael M]

Right click on the "PV Calculator " sheet tab and select "View Code"
In the left hand window, double click on the sheet "PV Calculator"

Now paste the code I provided in the right hand windowSave and close the window.

It should now work as required.

Sub worksheet_selectionChange(ByVal target As Range)
If Range("GB12").Value = 1 Then Rows(9).EntireRow.Hidden = True
If Range("GB12").Value = 0 Then Rows(9).EntireRow.Hidden = False
End Sub

I believe they will both do as required, but the code from Yahya will be more efficient.

 

[rintelen]

This I hope would work but there is already a macro in that part. So when I do View code I see this:


Private Sub worksheet_selectionChange(ByVal target As Excel.Range)
With target
If .Count > 1 Then Exit Sub
If .Address(False, False) = "C17" Then _
Range("C18").ClearContents
If .Address(False, False) = "C17" Then _
Range("C75").ClearContents
End With
End Sub

If I paste your routine after or before this it doesn't work. What do I need to do please?

Also will these hide and unhide the row or will it just do it once?

 

[rintelen]

It works on its own without the above but it doesn't update until I click something on the sheet? I want it to be instant. But I do need the above. So How can I get both to work please.

 

[rintelen]

I'm wrong. It does work but I have to click somethign before it fires up.

I need it to be instantly updated upon arrival at that sheet.

But I cannot make it work if I have that other macro there. I need both to work.

 

[Michael M]

You can't have more than one instance of a macro in a Worksheet_Change event.
So, if you have to run 2 macros via that method, you will need to combine them.

 

[rintelen]

How do I combine them please? And keep the protection switched on during each phase of hide or unhide when the value changes.