Need to pop up message box when vba project password protect unlock

Hi ,

I have an issue with unlock vba project.
I need to do following.
1). When vba project unlock message popup say "If wrong password attempt VBA CODE will delete"
2). If the user attempt more than three need to delete macro module.

If any body have any clue as how above mention two stept automate in excel(VBA MACRO) Please let me know.
Now I'm really sufferng with this issue. I gone though several thread, But no one has clear idea on that. Pleassss

Thanks,
Harsha

Unprotecting a project does not run any events. This would be futile anyway because your protection can be removed without trying any passwords (I say no more than that).

Hi Izandol,

Thanks for your quick respond regarding my issue.
I can protect VB project by Property mannually.
What I want is I want to popup a message to other users who try to unprotect project without my permission.
If they attempt to unlock project 3 time with wrong passwords The 4th attempt will remove all the macro module in particular work book.

Hope this is clear enough about what I looking at.



Thanks,

Harsha

Hi Andy,

As I attached bellow. I need to popup a message when other users trying to unprotect VBAproject and if they type wrong password more than 3 time the existing all modules in that project will remove or remove all VBcodes of the MODULES.
teat.png

Thanks,
Harsha

Further, if your project is locked how will you remove the code?

No I though, if the attempting is wrong we can pass the correct password through code and remove the module.

Any how thanks for both of you to help me out on this and clear it out all the scenarios.