Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a password protected workbook. I keep getting
errors with either of the following lines. Range("F8:F13").Font.ColorIndex = 3 Range("F8:F13").Font.Color = RGB (255,0,0) This selection is currently white font, and upon running the macro I would like to show it to the user (change the font to red). When I unprotect the workbook, the macro works fine. TIA, Brad E. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing font style and color using VBA | Excel Discussion (Misc queries) | |||
Changing font color if conditions are met | Excel Worksheet Functions | |||
Font color changing by itself | Excel Discussion (Misc queries) | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Changing Font Color | Excel Discussion (Misc queries) |