To create an Excel add-in file, follow these steps: 1. Load the workbook that is destined to become your add-in. 2. Start the Visual Basic Editor by pressing *A**LT**+11*. 3. At the very top of the Project window, select the bold entry that declares the name of the VBA project that is open. 4. Choose the Properties option from the Tools menu. This displays the Project Properties dialog box. 5. Make sure the Protection tab is selected. 6. Make sure the Lock Project For Viewing check box is selected. 7. Enter a password in both fields at the bottom of the dialog box. 8. Click on OK. The dialog box closes. 9. Close the Visual Basic Editor and return to the Excel workbook. 10. Choose Properties from the File menu. This displays the Properties dialog box for your workbook. (To display the Properties dialog box if you are using Excel 2007, click the Office button and then choose Prepare | Properties.) 11. Make sure the Summary tab is displayed. 12. Make sure the Title field is filled in. What you enter here will appear in the Add-Ins dialog box used by Excel. 13. Make sure the Comments field is filled in. What you enter here will appear in the description area of the Add-Ins dialog box used by Excel. 14. Click on the OK button to close the dialog box. 15. Choose Save As from the File menu or, in Excel 2007, click the Office button and then click Save As. This displays the Save As dialog box. 16. Using the Save As Type pull-down list, specify a file type of Microsoft Excel Add-In (*.xla). 17. Specify a name for your add-in file in the File Name field. 18. Click on Save. Your add-in file is created. 19. Close the workbook you just saved as an add-in.
To use the add-in is follow these steps: 1. Choose Add-Ins from the Tools menu. This displays the Add-Ins dialog box. (Display the Add-Ins dialog box in Excel 2007 by clicking the Office button, clicking Excel Options, and then clicking Add-Ins.) 2. If your custom add-in is visible in the dialog box, click the check box beside it and skip to step 6. 3. Click on the Browse button. Excel displays a standard file dialog box. 4. Use the controls in the dialog box to locate and select your custom add-in. 5. Click on OK. The add-in is loaded and made a part of Excel. (You can tell that the add-in is available because it is now listed in the Add-Ins dialog box.) 6. Click on OK to close the Add-Ins dialog box. On Mon, Nov 24, 2008 at 2:00 AM, kamlesh jain <[EMAIL PROTECTED]> wrote: > Dear All, > > Can any one help me.... How to convert excel macro to Excel Add Ins (.XLS) > > Thanks in Advance, > > Regards, > > Kamlesh > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
