Label issues

Posted by BobJ on February 05, 2002 12:29 PM

FreezOn is a label, if it is "off", how would I
Change the font color to red (Colorindex of 3).
I have tried several ways and keep getting errors.
Thanks in advance. Bob

' Are the Panes on or off?
If ActiveWindow.FreezePanes = True Then
FreezeOn.Caption = "On"
Else
FreezeOn.Caption = "Off"
End If

Posted by Juan Pablo G. on February 05, 2002 1:47 PM

Try with

.ForeColor = RGB(255, 0, 0)

Juan Pablo G.

Posted by BobJ on February 05, 2002 1:54 PM

Thanks...It worked great!