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?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |