View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad E Brad E is offline
external usenet poster
 
Posts: 7
Default Changing Font Color

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.