opening object when text in cell is red

[Vetequk]

I have this code in an excel worksheet which opens a word dcoument when you double click a certain cell (In this instance A1 or A3).
What I would like this code to do is open the doc only if say the text in the cell is red.


Thanks
Vetequk

Please Login or Register  to view this content.

[royUK]

How is the red colour achieved? Conditional Formatting or Format->Cells?

Does the posted code work?

Please Login or Register  to view this content.

[Vetequk]

Yes the code seems to work ok.
The text color is format is by the cell eg cell would be highlited by the user & assign the appropriate font color from the excel menu

[snb]

Please Login or Register  to view this content.

[Vetequk]

snb
thanks that pointed me in the right direction, I juust changed the word interior to font & reomved all the dim statements.

Vetequk