ActiveX

To set the odd and even row colors

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Call the SetOddEvenRowColor method.