Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Correction: The "WS" in the code should be "Web System"
Tyro "Tyro" wrote in message ... You're checking only for a change in Column C. There is no reference to row 7. Your code should look something like this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 And Target.Row = 7 Then If Target.Value = "WS" Then Columns("E:F").Hidden = False Else Columns("E:F").Hidden = True End If End If End Sub Tyro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro/code to hide rows | Excel Worksheet Functions | |||
Hide VBA code help | Excel Worksheet Functions | |||
How to hide VB code from Excel file | Setting up and Configuration of Excel | |||
When i hide columns it hides whole sheet | Excel Discussion (Misc queries) | |||
Hide Code | Excel Discussion (Misc queries) |