When you encounter a password prompt while opening a ZIP file, then it means that archive is protected with a password. Unfortunately, there is no application (although many say it will remove the password) to crack the password. Of course, many of those applications will allow you use Bruteforce to recover the password. The chance of success is close to 0 %, and it's time consuming.
You need to contact the one who created the archive and ask for the password. It's the easiest and most convenient way.