Summarize:

(For example, if your code works with MS Excel, create an Excel file.) " (You may need to select macro "Options" to be able to insert the description.) (In the Visual Basic Editor, look under the "Debug" menu and select "Compile VBA Project.") " (You may also need to set a password, depending on the specific file type you're working with and your settings for MS Office and your computer.) Save a Microsoft Word add-in as a DOT file, a document template. (If you want the add-in to run when you start Word, save it in the Word Startup folder.) Save a Microsoft Excel add-in as an XLA file. Save a Microsoft Access add-in as a MDE file, which will protect the VBA code. (Microsoft Access add-ins can also be saved as MDA files, but this doesn't hide the code.) Save a Microsoft PowerPoint add-in as a PPA file which will hide the VBA code and leave it unable for anyone other than you to access it or edit it. Your add-ins should now be usable.
Create an empty Office file of the type that will use your code. Copy your VBA code into the Visual Basic Editor of that empty file. Open the "Macros" window, usually stored under "Tools. Test your code again, which debugs it. Remove anything added to the empty file by your test. Add a description to the macro that will run in your add-in. Compile your code. Save a copy of the file in a standard file type. Go to "Tools" in the Visual Basic Editor, then select "Project Properties. Select the "Protection" tab. Activate the "Lock Project for Viewing" check box. Open the "Save As" or "Save a Copy" dialog box. Access the drop-down menu and change the file type to the appropriate type of add-in. Quit and reopen Microsoft Office.