Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Change in Excel 97 does not run first time
Try the below. Right click the sheet tabViewCode and paste the below Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Target, Range("A1")) Is Nothing _ Then Application.Run "HideRows" Application.EnableEvents = True End Sub If this post helps click Yes --------------- Jacob Skaria "Monk" wrote: I am using the following code to run a Macro when there is a change in cell A1. This works well on excel 2003, however it does not run automatically on excel 97. If the user changes the value in A1 for a second time in 97 then the code will work. If you could provide advice on what code would work on the first change in 97 and later versions it would be appreciated. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("a1")) Is Nothing Then Exit Sub Else Application.Run "HideRows" End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get the date and time if a change is done in a worksheet | Excel Discussion (Misc queries) | |||
Worksheet change time format | Excel Programming | |||
Time Format on Worksheet Change | Excel Programming | |||
Time format via Worksheet Change | Excel Programming | |||
how do i change all text case in a given worksheet at one time | Excel Worksheet Functions |