Activate a worksheet after two attempts

[ramatthews]

Hi All, I have the following code:

Please Login or Register  to view this content.

I would like to allow a user to carry on after two attempts. Therefore, the code should not take the user back the entire time, rather bring it under the attention of the user.

I hope this makes sense, and that someone can assist me.

[karedog]

Maybe :

Please Login or Register  to view this content.

[ramatthews]

Thank you, I will test this now. The problem is, I have the following page which I also needs to amende to form part of the test. The code on this page is as follows:

Please Login or Register  to view this content.

How wil I change this if there is two seperate variables?

[karedog]

You are welcome.

Put this code in sheet module :

Please Login or Register  to view this content.