Tamer,

Do the following:

1) Press ALT+F11 to open the VBA Editor.
2) There, go to the Insert menu and choose module.
3) In the Module, paste the following code

Sub ColorRows()
Dim RowNdx As Long
For RowNdx = 1 To ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastC ell).Row
_
Step 2
Rows(RowNdx).Interior.ColorIndex = 15
Next RowNdx
End Sub

4) Flip back to Excel
5) Pres ALT+F8 to display the Macro dialog
6) Choose ColorRows and click Run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Tamer Seoud" wrote in message
...
Hi,
I never did Excel programming before, but I do VB
programming. I have a spreadsheet with many rows and
columns, to make it more easy to read the data in each
row, I was wondering if there is a way to program the
spreadsheet the way that every other row is grayed out.
Please help and please tell me how to access Excel modules
to type in the code.
Thanks a million.
Tamer