password protected excel file

[methode2404]

Hi,

It is possible to write a macro, for closing password protected excel file, on wrong password entry and no-entry for 10 seconds.

regards
Metin

 

[MARK858]

just for info:

any smart user can break the sheet/vba project password very fast then he can see password contained in vba code
you can try obfuscate vba code and it will be quite a difficult time to recognize the password in the code
maybe any vba master will do that for you

have a nice day

If they have the knowledge to get around the VBA protection then they have the knowledge to bypass any other password the OP sets via a macro just as easily.

I need the code for : Closing workbook on wrong password entry and closing workbook if there no entry in 10 seconds

methode2404, if they haven't entered the password correctly when the dialog comes up to unprotect the workbook (via the workbook protection) then the workbook has never been open. They only have the option to cancel the opening at that stage.

 

[sandy666]

If they have the knowledge to get around the VBA protection then they have the knowledge to bypass any other password the OP sets via a macro just as easily.

sure, enough to stop run macro/vba on open file the you have access to everything but obfuscated vba code is very hard to read and recover the code (password)
protection in Excel is illusory

 

[MARK858]

obfuscated vba code is very hard to read and recover the code

Not that hard (obviously you could compile the code to to a DLL or EXE using something like C++ which makes it more difficult) but the objective of the OP is to set a password via a macro which if incorrect closes the workbook which is even easier to bypass without touching the VB Editor.

At the end of the day VBA is just not secure and so it just depends how much knowledge (determination) the users have.

 

[sandy666]

@MARK858
whatever you say, it was just info about protection in Excel which, as I said before, is illusoric.

 

[peter111]

This won't work... user can just stop any macro from running in trust center by disabling macro...