The auto_open procedure runs each time you open the workbook.

Make sure it's in a general module--not behind a worksheet or ThisWorkbook.

If you wanted to highlight the cell, use the conditional formatting solution.

If you wanted to select that cell, try the auto_open code.

And opening the workbook is a particular event--so I don't quite understand your
question.

"Ekser <" wrote:

Thanks Dave!

However, it doesn't seem to give a result...I copied exactly the same
code.
There is also something I'd liek to know: how cane we trigger such a
module without executing a macro?
e.g. I have a module I would like to be triggered each time the
WorkSheet is opened and not on a particular event - how to do this?

Thanks!

P.S. The solution I posted afterwards works fine!

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson