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

 

[oldbrewer]

yes - but a user who gets in 30 seconds later could amend the macro........

 

[MARK858]

If it is the same workbook and the only one open then when you close the workbook the macro will stop running. You can run a timer for 10 seconds before it closes but I don't see the benefit.

 

[methode2404]

I have a lot of user, they have to entry some data on their xls file and start a macro. This macro copy paste the data to "master'' xls.
This master xls should be closed for all time.
Some users could open (because of curiosity) the master xls. (master xls is password protected)
Master xls should close itself with wrong password entry, or also with no-entry

I have to make sure the master.xls is always closed.

 

[MARK858]

If master.xls is protected how are they opening it?

 

[methode2404]

in Macro of users xls is the password from master xls defined.

 

[MARK858]

Have you not hidden and password protected the VBA project?

 

[methode2404]

In the end , i will protect user xls VBA with password. its no problem

 

[sandy666]

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

 

[methode2404]

The password for VBA is not so important.
I need the code for : Closing workbook on wrong password entry and closing workbook if there no entry in 10 seconds