We work lot in excel and manage our work with functions and macros. I am here creating the process that will save your time and effort to re-create again and again the same functions or macros.
Here we are going to create Add-in that will automatically load when you open your excel, and the function will be available all the time. So let's start.
Step 1: Quickly create an empty add-in for excel
- Open excel and Save a blank workbook as a Excel Add-In (*.xlam) in your Add-In folder (%UserProfile%\AppData\Roaming\Microsoft\AddIns)
- I named it PersonalAddIn.xlam (Save it with any name you like)
- Click Office button.
- Click "Excel options" button.
- Click "Add-Ins" tab.
- Select "Excel Add-ins" from manage dropdown list and click GO
- Click "Browse" button
- Select the (.xlam) file that you just saved in step 1
- Click OK (Make sure you enable)
Step 2: Add custom functions and macros to your personal add-in
- Go to the Developer Tab on the ribbon.
- Click "View Code"
- Click on the project panel you see VBAProject (*.xlam)
- Click Insert Menu --> Module
- Copy and paste custom functions and macros to code window.
That's it... we are done.
Step 3: Use your user define function
- Go to the cell
- Click "Insert Function" in formula bar
- Select category "User Defined"
- Select your custom function
- Click OK
Step 4: Use your user define Macro
- Go to "Developer" tab
- Click "Macros" button
- Select/Type the macro name
- Click "Run"
Hope this will help you in you daily work, In case of any query you can write to me. Thanks for reading.
No comments:
Post a Comment
Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.