View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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.