Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro error
This is the Macro im using & i know why im getting an error (i have a
password for protecting structure) is there any possible way i can do this & change Macro to accomodate & how i am not very good with Macro,s Private Sub Workbook_SheetChange(ByVal Sh As Object, _ ByVal Target As Range) Dim myRngToInspect As Range Set myRngToInspect = Sh.Range("C300") If Target.Cells.Count 1 Then Exit Sub End If If Intersect(Target, myRngToInspect) Is Nothing Then Exit Sub End If If UCase(Target.Value) = UCase("QC") Then Sh.Tab.ColorIndex = 3 'red for me Else Sh.Tab.ColorIndex = 2 'White for me End If End Sub s is the Macro im using & I know why im getting an error |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro error
Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Range) Dim myRngToInspect As Range Me.Unprotect "password" Set myRngToInspect = Sh.Range("C300") If Target.Cells.Count 1 Then Exit Sub End If If Intersect(Target, myRngToInspect) Is Nothing Then Exit Sub End If If UCase(Target.Value) = UCase("QC") Then Sh.Tab.ColorIndex = 3 'red for me Else Sh.Tab.ColorIndex = 2 'White for me End If Me.Protect "password" End Sub --- HTH Bob Phillips "Mike" wrote in message ... This is the Macro im using & i know why im getting an error (i have a password for protecting structure) is there any possible way i can do this & change Macro to accomodate & how i am not very good with Macro,s Private Sub Workbook_SheetChange(ByVal Sh As Object, _ ByVal Target As Range) Dim myRngToInspect As Range Set myRngToInspect = Sh.Range("C300") If Target.Cells.Count 1 Then Exit Sub End If If Intersect(Target, myRngToInspect) Is Nothing Then Exit Sub End If If UCase(Target.Value) = UCase("QC") Then Sh.Tab.ColorIndex = 3 'red for me Else Sh.Tab.ColorIndex = 2 'White for me End If End Sub s is the Macro im using & I know why im getting an error |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Macro Error | Excel Discussion (Misc queries) | |||
Macro error : Application-defined or object-defined error | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |