how to prevent user from clicking a button on error

[ballack]

Hi all,

I have the following code

Please Login or Register  to view this content.

In this code i am checking if the user types any special characters in name.
If so then on selection change i ll show a msgbox and select that cell again for the user to correct.

But the problem is the user can click on a button in my excel and go to the next tab,

How can i prevent him from clicking the button in this case?

Please help me with this...

Thank you,
Glen

[rylo]

Glen

Would making it a change event instead of a selectionchange event beat the problem? Just a thought and not tested at all....


rylo

[ballack]

Thank you Rylo .

I tried to do the check on click of the Button . so when user clicked the button , i call a function and did the check on all the rows if any names have special characters .

This works now

Thank you.