Close the document, then reopen, go to the Developer tab and click Visual Basic. Now we can check if the newly created password is working. Ĭlick OK, make sure you saved the Excel document as an XLSM file. You also need to check the box next to Lock project for viewing. Go to the Protection tab to set the password. In Visual Basic Editor, navigate to Tools> VBAProject Properties. It has no real purpose, but here, we need to create a file for password protection. This is a simple macro that allows the text to be quoted in cell A1. Once you have selected Macros in the Developer tab, enter a name for your Macro (this is just an example, so you can enter another name as you like), then click Create.Ĭopy and paste the code below into the Visual Basic Editor. Now move the Developer command group from the left panel to the right. If you don't see the Developer tab, go to File> Options, then select Customize Ribbon. Go to the Developer tab in Excel and click Macros. However, here, I will talk about how to set up this type of protection. If you are trying to crack the VBA password, you probably already know how to set it up.
0 Comments
Leave a Reply. |