Pick Random values from the list to run macro (simulating captcha function)

[bambino86]

Hello,

I have a file that has a delete data code in it. However, I want to make sure that users do not accidentally run the code and delete the data. Is there a code that can simulate a captcha function? Or a code that can randomly pick from a list, show the random value and in a message box and the user should match the random value before the delete data code can run?

[kersplash]

Or an "Are you sure?" msgbox?

[bambino86]

Or an "Are you sure?" msgbox?

Yes I do have that as well. But there is still a possibility that the user will unconsciously press the enter key and all the data will be gone.

[bambino86]

Anyone please? thanks

[scottiex]

Make them type "Yes" into a input box that asks if they REALLY want to delete it?

[scottiex]

Regardless you could use an input box something like this. Edited to suit of course.

Please Login or Register  to view this content.

[Akuini]

Anyone please? thanks

another option:
Try this:
Put this code in the beginning of your macro

Please Login or Register  to view this content.