VBA - Password Protect a Workbook

[Pacman52]

Hi all could someone please remind me of how to code a workbook so its password protected so a user has to enter the password the next time its opened. I have done this before on some old projects but it was so long ago I just can't remember how.

Just for info, I know this is not very secure and its fairly easy to crack excel passwords but the workbook I am trying to protect is only going to be used by my wife and it will give her a feeling of it being 'secure'

Thanks Paul

 

[Joe4]

Have a look here for instructions: Protect an Excel file - Microsoft Support

 

[Pacman52]

Thanks Joe I can't believe I forgot how simple it is to do this and was over thinking it in my mind !

 

[Joe4]

You are welcome.
Glad I was able to help!