Need a solution for auto delete workbook

[grix25]

Hi all,

I need a solution for deleting workbook if someone put incorrect password, let's say 2 or 3 times.
I saw some tutorials where you can delete a row in code of xslx. by renameing it to .zip and editing original code to remove password, so I need solution which that hack will not work.

Thx

[Kaper]

Have in mind that user could make a copy of the workbook before first attempt and even if workbook is deleted after 3 passoword failures can use a copy :-)

I think already in version 2013 there is File->info->protect->encrypt which offers quite strong protection. The solutions with renaming file to .zip and editing don't work on that type of protection.
Of course user can make many attempts, but if the password is not predictable, (like one of team members name + current month) it is an effective way to protect.

PS. Test it on the attached file