What do you mean by "rules"
If you mean gridlines, there are two ways
1) In Tools | Options | you can uncheck the Gridlines box
OR
2) Use a fill (white will do) on all cells

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John A" <John wrote in message
...
I'm looking for a macro to clear rules from all my worksheets of a
workbook.