| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 macro does not work
The following macro was working in E2003, now that I've converted to E2007 is
does not. Any ideas? Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Range("D7"), Target) Is Nothing Then Range("A29:A42").EntireRow.Hidden = False If Target.Value = "Refund: Client requested a cash refund." Then Range("a29:a32").EntireRow.Hidden = True ElseIf Target.Value = "Write off (Bad Debt): Client unwilling to pay and determination made to stop collection process." Then Range("a33:a42").EntireRow.Hidden = True Else Range("A29:a32").EntireRow.Hidden = True End If End If End Sub -- Maritza |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2007 macro does not work
In what way does it not work ?
Tim "Maritza" wrote in message ... The following macro was working in E2003, now that I've converted to E2007 is does not. Any ideas? Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Range("D7"), Target) Is Nothing Then Range("A29:A42").EntireRow.Hidden = False If Target.Value = "Refund: Client requested a cash refund." Then Range("a29:a32").EntireRow.Hidden = True ElseIf Target.Value = "Write off (Bad Debt): Client unwilling to pay and determination made to stop collection process." Then Range("a33:a42").EntireRow.Hidden = True Else Range("A29:a32").EntireRow.Hidden = True End If End If End Sub -- Maritza |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why doesn't this simple macro work in excel 2007? | Excel Discussion (Misc queries) | |||
| macro does not work in Office 2007... suggestions: | Excel Discussion (Misc queries) | |||
| EXCEL 97 WORK IN 2007? | Excel Discussion (Misc queries) | |||
| Why doesn't this work in Excel 2007? Is this a bug? | Excel Programming | |||
| Lost all my work in Excel 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
