Excel - Detect multiple password attempts

[Xaqte]

I know it won't be foolproof, but I need a way to detect multiple password attempts then close the application after X attempts.

Any thoughts or experience would be greatly appreciated!

X

 

[xlbo]

probably better setting up a userform that shows on open and asks for a password - you can then easily track attempts and close the app as and when you wish

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[KenWright]

You can then also write a date & time value into the file somewhere (Assume you want a half hour window say) and then have the code instantly close it if it is opened again within that window of time.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[Xaqte]

Thanks for the responses!

The user form is a good idea, but it won't work for this current project b/c I don't want to deter the ordinary user from entering data into the workbook.

I just have a couple of people who insist on cracking the password, then changing the functions... and wondering why it doesn't work. Unfortunately, terminating these people is out of the question.

 

[xlbo]

They can crack workbook passwords ??

worksheet I can understand but if they are cracking workbook passwords, there will be very little you can do other than wrapping the workbook up in a VB project....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[KenWright]

Even that isn't safe now. A hex editor and changing the right string of values, and the VBA protection is toast.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[SkipVought]

I'll have my toast with blackerry jelly and java.

Skip,

_[red][/red]

 

[KenWright]

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[combo]

If you like to stay purely in excel, separate data and code by creating password protected add-in. Next this dirty thing can protect from cracking vba project: with hex editor try to find and clear (to 0s or other values) some of not compiled code (excel, unlike access, doesn't remove uncompiled code from the add-in).
Any saving or unprotecting of such file will crash excel. The add-in is here to avoid temporary saving the file. And test the stability for the add-in on your machines.

combo