You were given a workable answer to your first post.

Jacob provided it.

You just did not follow his steps.


Gord Dibben MS Excel MVP

On Thu, 12 Nov 2009 09:33:01 -0800, Jim
wrote:

First of all, please excuse the re-post, but I didn't receive a workable
answer to my original post. Please see below, Thanks....

We have a workbook with multiple worksheets. I have written a procedure
which checks for data outside of a specified range on the worksheet.

Is it possible to have this procedure run automatically whenever a user
activates a new worksheet in the workbook? I realize that the procedure can
be tied to a key combination, or command button, but that requires input from
the user. For this application, we need to automate the process.

Thanks,

Jim