Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert macro into formula
I would like to insert a macro into my worksheet that will hide or unhide
rows of the worksheet based on the input value of a cell. For example, if the user enters "Y" (for yes) in a cell, I want the next two rows below the input cell to unhide. If the user enters "N" or "N/A", I want the next two rows to remain hidden. Thanks! |
#2
|
|||
|
|||
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("H1:H10")) Is Nothing Then With Target If .Value = "Y" Then .Offset(1, 0).Resize(2).EntireRow.Hidden = False ElseIf .Value = "N" Or .Value = "N/A" Then .Offset(1, 0).Resize(2).EntireRow.Hidden = True End If End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "Paul" wrote in message ... I would like to insert a macro into my worksheet that will hide or unhide rows of the worksheet based on the input value of a cell. For example, if the user enters "Y" (for yes) in a cell, I want the next two rows below the input cell to unhide. If the user enters "N" or "N/A", I want the next two rows to remain hidden. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a line feed in a formula? | Excel Worksheet Functions | |||
How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
insert a new cell into an existing formula | Excel Discussion (Misc queries) | |||
repeat macro formula to all cells | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |