I want to use external data validation. I know how to do it. What I
want to do is have a macro that automatically tells the user that the
external workbook needs to be open and will then open it. Does anyone
know how to do this?

Do I use a change event on the validation error?

Thanks in advance.

Shane