Add password in a button code to complete the action

[Immortal2014]

Hello, i want to make a button to clear specific contents from my book. I find a code and i want little help to add some security on this

Please Login or Register  to view this content.

Now here, when i click on button, inform me for complete clearance of the contents ( are you sure for the contents clearance?). After the agreement, i want to ask me for personal password twice and then after clicking ok to completing the clearance.

Ranges are indicatives.

[Gatti]

Hello my friend

Try this:

Please Login or Register  to view this content.

If it solves your problem, please mark the Thread as [SOLVED] and add reputation.

Give me a feedback

Thanks :D

[NeedForExcel]

Give this a try -

Please Login or Register  to view this content.

[Immortal2014]

Both options work nicely! But, according to what I asked, closer is the code of Deep Dave. Thanks both of you for the help!
Can i have in all msgboxs titles and not "Microsoft Excel" ?

[Immortal2014]

Give this a try -

Please Login or Register  to view this content.

When i change the password XXX with alphanumeric and trying to work the button it says Passwords Don't Match. What i'm doing wrong?

[Gatti]

@Immortal2014

Try changing:

Please Login or Register  to view this content.

So you will be abble to put any kind of value

Don't know if it solves your problem anyway

Don't forget to put it in " "

[NeedForExcel]

When i change the password XXX with alphanumeric and trying to work the button it says Passwords Don't Match. What i'm doing wrong?

It should work, as long as it is between ""

I tried with this

Please Login or Register  to view this content.

and it happily worked..

If you are still having issues, please attach the file if possible..

See the file attached, the Password is "D12"

[Immortal2014]

I'll try both solutions and if it happened again then I'll upload a sample. Thanks again.

[Immortal2014]

Well, i found what was going wrong with the phrase "Passwords don't match". In my personal password using uppercase, lowercase and numbers, with no results . I try only with uppercase, numbers and special characters and the password is accepted. Why this happened?

String & Variant works well too.

[NeedForExcel]

That is coz I am using the UCase function to change any input to upper case..

Get rid of it, and It should work as required.

[Immortal2014]

In this situation can I delete the UCase from tho lines of code? Sorry for my questions but I'm not familiar with vba..

[NeedForExcel]

Not exactly..

Try if this works.

Replace

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

Let me know if it works..