Thanks, Its Working .. Great Help. Can you also help out how it wil appear in excel menu Bar or Button.
Regards, Kamlesh On Tue, Nov 25, 2008 at 2:49 AM, Tom Jeffries <[EMAIL PROTECTED]> wrote: > 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 >> >> >> > > > > -- Regards, Kamlesh Jain --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
