Free Excel VBA Course #32 - Creating Excel Add-ins

In this video, I will show you how to create an add-in in Excel.

Once you have created an add-in, you can share it with others as well. With an add-in, once you have installed it, you will be able to use the add-in code in any workbook on your system.

-------------------------------------------------------------------------------------
0:00 - Introduction
0:13 - Creating a Custom Function
1:52 - Using Custom Functions
3:39 - Saving Add-ins
4:45 - Adding Add-ins
6:19 - Saving and Protecting Add-ins
-------------------------------------------------------------------------------------

#ExcelVBA #ExcelTips #ExcelTutorial

[roshansonkamble]

Thank you. I was searching for this stuff.

[amitfore]

Very Useful Video. Does the same procedure of saving add ins work in excel 2007 also???

[rajeevgosavi]

Video is very helpful. Good technique. However download file link provided by you is not working. Also request you to please provide VBA code

[richardlevine]

Very nice. First clear and to-the-point explanation of Excel Add-ins that I have found. Can you make a video showing how to make an add-in that adds some menu options to the ribbon? Or that makes a form off of which we can execute more macros. Thanks for the effort you put into this one.

[gertdebeer]

I am looking for a tutorial on how to create a COM addin. I want my functions to only be able to run from a click event and not be visible as a function that can be called from a cell

[munawarmahtab]

can you explain how the program works?

[R_K_ENTERTAINMENT]

Sir i want to highlight only active cell in every active worksheet and when I go other cell pervious get back normal
How to write a vba code for this

[mayurlad]

Sir I have created an formula for getting Age with DATEDIF formula I saved that excel into xla as well on xlam....and i have added into all others excel through addins but still that formula is not getting done can you please help to get this done.. please it's my kind request

[robbysandhu]

But the question is how I can give Keyboard shortcut to this?

[rajeevgosavi]

SIR, CAN YOU GIVE US THIS VBA CODE TO DOWNLOAD

[rajeevgosavi]

Sir, I have office 2021 latest, but still this formula ( =sing) does not open by default. Could you please share VBA code for that please.