Hi Ashish Save your file as .xla (the last extension in 'save as type' box. When you choose this extension the folder automatically changes to addins. Save the file in this addins folder.
Then restrart the excel and from tools->Addins activate your addin and use it as macro or function. Regards Sandeep ----- Original Message ----- From: ashish koul To: excel-macros@googlegroups.com Sent: Wednesday, September 09, 2009 9:54 AM Subject: $$Excel-Macros$$ hey thanks for your help hi just wanted to ask how t make an addin and make it visible in excel 2007 and also can i use macro as add in or i have to create function to put as add in like a make a proper macro how can i put it as add in Thanks all Regards Ashish --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
