View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Louis[_4_] Louis[_4_] is offline
external usenet poster
 
Posts: 2
Default .Font.ColorIndex Delay Question

I have run into a problem when I code using .Font property. I am using
Excel 2003.

The code can be anything that calls up the font property, like
Cells(1,1).Font.ColorIndex = 3

When Excel runs it the first time, it takes quite a few seconds to
accomplish. However, after that,it runs at speed.

This also happens if I format a cell's font the first time I access the
font property in Excel wihtout using code.

Is there a way to get around this delay? Or is it my copy of Excel?

As I said, once Excel opens up the font property, it calls up the font
in a normal speed after. No more delay.

I appreciate any help on this issue.

Thank you.