Unprotecting sheet after running a macro

[Michell Feitosa]

Hi Guys,

I have this macro msgbox running in my protected sheet, by the time I select "Cancel" on the message box, my sheet become unprotected.

I'd been done a few test, and my sheet just be unprotected just when I select "Cancel" on the macro message box.

Could you help me to fix this problem?

This is my macro:

Please Login or Register  to view this content.

[/CODE]

[HaHoBe]

Hi, Michell Feitosa,

please use Code-Tags for displaying your code.

Move the line to unprotect after the checking of the input like this:

Please Login or Register  to view this content.

Ciao,
Holger

[blobbles]

Try this:

Please Login or Register  to view this content.

Next time use CODE tags, or we will smash ya up! (Not really, probably just tell you to use code tags again!)

[blobbles]

Holger's is better, use his!

[Michell Feitosa]

You are amazing! thank you so much