On Tue, 5 Apr 2005 19:01:43 +0200, "Ron de Bruin"
wrote:


If you change the takefocusonclick property of the button to false
you don't see the 1004 error (bug in 97)

The code is working for me in Excel 97 as a sub and in the click event of the button

But if your colors are a result of Format conditional formatting it is not working.
Is that true ?

Thanks, Ron. That has sorted it !

It works perfect now.

Many thanks.

Ian,