The next section of the article will address the problem of opening a password-protected Excel file without a password. Now that you know how to password protect an Excel file, you must also know how to unprotect it if you ever lose the password. Next time when you open the Excel file, you will need to enter the correct password to make any changes. When the Save As dialog box appears, click on the Tools link beside the Save button.Ī new dialog will appear to ask you to enter a password.

Open the Excel file, go to File menu and click on Save As.

Instead, you can just limit the actions that could be performed. Read-only access is the best option if you do not want to make the file fully confidential. Simply put, using read-only access, you can determine which users can access, update and edit the file's contents. Restricted access means limiting the actions that could be performed on a sheet. If you do not want to make all the data and settings inaccessible to other users, you can avail the option of restricted access in MS Excel. No one can intrude on your private data now. Now, check the box in front of the 'Lock project for viewing' if you want to lock it else, set the password and click OK to save settings.īingo! You have protected your Excel file with VBA successfully.

Open the Protection tab when the Project Properties dialog box appears.

Now, go to the Tools menu and click on VBAProject Properties.

Now enter the Macro name and click on Create button. Open the Excel file you want to protect and go to the View menu.Ĭlick on the Macros option to create a new Macro.If you want to put password on Excel file using VBA, the following are the steps: it is a programming language that you can use to personalize your Office Applications. It is used to automate the Office applications such as MS Word, MS PowerPoint, MS Excel, etc. VBA is short for Visual Basic for Applications. You have successfully protected your data from unauthorized access. Next time, when you open the encrypted file, you will need to enter the correct password. Re-enter the password and click OK again. Search for the 'Encrypt with password' option and click on it.Įnter the password you want to set on the file. Open the Excel file and go to the File menu.Perform the following steps to encrypt an Excel file:

Encrypting means that whenever someone opens the file, they will have to enter a password. The most common way to protect an Excel file with a password is to encrypt it. Putting a password on an Excel file is not a big deal, but if you are a beginner and do not have enough experience, the following methods will definitely help you! Method 1: Encrypt an Excel Document: Part 1: How to Put Password on Excel File?

How to put password on excel file