If you have sensitive data you'd like to keep from prying eyes in a Microsoft Excel file, the easiest way to protect it is with Excel's built-in password tools.

VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

In Word, Excel, or PowerPoint for Windows, open the file you want to protect with a password, then select File and Info. You should see a Protect option at the top of the next list: Click this ...

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.