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.
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