Hectoe,

Thx for your time, I am sorry I miss understood - I thought I needed to a
selectchange event IF it was excel 2002+ not AND.

Again thanks fro your time

Scott

"Héctor Miguel" wrote:

hi, Scott !

... i get the error "run-time error 438 Object doesn't support this property or method"
and then the VB Editor highlights the code line:
With Worksheets("sheet2").Tab
(...)
I am running Excel 2000.

I think you missed this part from my proposal...

(note you will need '_selectionchange' event to be triggered and excel version 2002/xp or above)

(I'm sorry but xl-2000 doesn't support tab color changes)

regards,
hector.