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