Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Trigger
Hi,
I've created a spreadsheet where I want rows to hide/reveal depending on the contents of a Cell. The code I used below works however every time I complete another cell on the spreadsheet the macro is triggered. Is there a way to only run the one time when you complete cell F18 and then have it disabled until you change that cell value again? Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = True If Range("F18").Text = "No" Then Rows("19:24").Select Range("A19").Activate Selection.EntireRow.Hidden = True Exit Sub ElseIf Range("F18").Text = "Yes" Then Rows("18:25").Select Range("A19").Activate Selection.EntireRow.Hidden = False Exit Sub ElseIf Range("F18").Text = "" Then Rows("19:24").Select Range("A19").Activate Selection.EntireRow.Hidden = True Exit Sub End If End Sub Thanks, Stringhaussen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trigger a Macro | Excel Programming | |||
Trigger macro on value only | Excel Programming | |||
macro trigger | Excel Discussion (Misc queries) | |||
Another way to trigger a macro? | Excel Programming | |||
Macro trigger? | Excel Programming |