Changing Font Color
Hi
you have to unprotect your worksheet in your macro and protect i again
afterwards. So something like
activesheet.unprotect password:="your password"
Range("F8:F13").Font.ColorIndex = 3
Range("F8:F13").Font.Color = RGB (255,0,0)
activesheet.protect password:="your password"
--
Regards
Frank Kabel
Frankfurt, Germany
Brad E wrote:
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.
|