protecting an excel sheet

[keyboard flier]

Hi,

I am wanting to protect an excel file with a password, then email that file to a third party and when they receive it they need the password to open. However every attempt I have tried so far hasn't worked because the recipient has been able to open the file without it asking for a password.
How the heck do I do it??

Thanks