Error using code to prevent editing of data with forms

Hi.
I'm trying to use a code to prevent editing of data in a spreadsheet.


But the data is entered via a form.

When I use the form to enter the data generates the following error below.

Run-time error '1004 ':
Method 'Undo' object '_Application' failed

Please Login or Register  to view this content.

Hi.
Any idea?

Thank you!!!

Hi.

I'll send the spreadsheet to improve understanding.

How big is the planilh (1.48MB), I had to deposit it at a site
http://www.sendspace.com/file/y4bqne

Thank you!!

Hi.
Any idea?

Thank you!!!

Hi.
the data that is entered on the form are entered in the spreadsheet, this time I want, that these data be blocked and when the user is editing some cells prompted the release.

Hi.

Thank you!!!

Hi marreco

Long time no see!!!

My understanding is that if the User changes a value in Column B, the User is presented with an Input Box. If the User types "alevba" in the Input Box the change is accepted; if the Input Box does not contain "alevba" or is empty or is canceled the change is rejected and the old value is restored.

If my understanding is correct the code appears to do just that. So, what error are you receiving (in English please?

Nevermind...I see the issue is SOLVED.

hello my friend, how long I do not see you too!!

The problem was fto I enter the data via the form.

but then I realized that there was a detail (failure) in code.

I was resolved, but I am very grateful for you trying to help, thank you!

Till we meet again...my best to you.