Event Programming - Cell Value change - 2 sheets involved - VBA - Excel
Hi,
I got an excel file consisting of 3 sheets.
I want to hide rows 53 to 88 in the last sheet called "Expense Report"
whenever there is a value (letters) entered in cell C6 in the sheet
"General Info".
I know I need a Worksheet_SelectionChange event and this is what I
came up with. However it does not work. This is what I programmed:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Sheets("General Info").Select
APPILCATION.Goto C6
If (ActiveCell.Value 0) Then
Sheets("Expense Report").Select
Range("53:88").EntireRow.Hidden = True
Else
Range("53:88").EntireRow.Hidden = FALSE
End If
End Sub
Any help?
Where do I need to put the code when I open the VBA-editor?
Regards
|