Hi John,
Wo\w! Thx for such a great reply, that is a great help for me. One query,
when you write that the macro has to be in the Workbook.Open Event, what is
meant by that?

Thx, I am very happy to get such a useful reply,
Mickey


"John Wilson" wrote in message
The above would have to be in the Workbook.Open Event as the
.EnableAutoFilter will not be there upon closing and reopening
the workbook.