Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate Event Before Saving
I want this event to activate before saving the file. Pls, can
anbody show me what is wrong or missing? Option Explicit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim icolor As Integer If Not Intersect(Target, Range("A6:n2000")) Is Nothing Then Select Case Target Case 15 icolor = 4 Case -15 icolor = 46 Case 100 icolor = 6 Case -100 icolor = 3 Case Else 'Whatever End Select For myloop = 1 To 14 ActiveSheet.Cells(Target.Row, myloop).Interior.ColorIndex = icolor Next End If End Sub I cannot figure this out... Pls help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate Event Before Saving
You have an active thread elsewhere.
J-D wrote: I want this event to activate before saving the file. Pls, can anbody show me what is wrong or missing? Option Explicit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim icolor As Integer If Not Intersect(Target, Range("A6:n2000")) Is Nothing Then Select Case Target Case 15 icolor = 4 Case -15 icolor = 46 Case 100 icolor = 6 Case -100 icolor = 3 Case Else 'Whatever End Select For myloop = 1 To 14 ActiveSheet.Cells(Target.Row, myloop).Interior.ColorIndex = icolor Next End If End Sub I cannot figure this out... Pls help. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate Event Before Saving
Target is not defined. I usually see Target as one of the parameters passed
in a worksheet_chage macro. This is a Before_Save which doesn't accept a passed range variable. "J-D" wrote: I want this event to activate before saving the file. Pls, can anbody show me what is wrong or missing? Option Explicit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim icolor As Integer If Not Intersect(Target, Range("A6:n2000")) Is Nothing Then Select Case Target Case 15 icolor = 4 Case -15 icolor = 46 Case 100 icolor = 6 Case -100 icolor = 3 Case Else 'Whatever End Select For myloop = 1 To 14 ActiveSheet.Cells(Target.Row, myloop).Interior.ColorIndex = icolor Next End If End Sub I cannot figure this out... Pls help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On activate event | Excel Programming | |||
Cell Activate Event | Excel Programming | |||
Worksheet Activate Event | Excel Programming | |||
Activate sheet event | Excel Programming | |||
Activate event | Excel Programming |