My First Add In. Having Issues

[bdunk]

I am playing around with Excel Add Ins. I created my first one and placed the .xla file in the Add Ins as instructed. I see the Add In in the Add Ins selection window when you go Tools - Add Ins. I have selected the check box next to my Add In to activate it. My question is how do I now execute my Add In. Do I have to make a custom toolbar button? I have tried this and cannnot get the Add In to fire.

Thanks

Bdunk

 

[Richard Schollar]

What are you expecting your add-in to do? Does it contain UDFs?

 

[bdunk]

Add In troubles

My Add In is this:

Sub Delete_Part_Qty1()
With Columns(3)
.Replace what:="1", replacement:="", LookAt:=xlWhole
.SpecialCells(4).EntireRow.Delete
End With
End Sub

This will look in Column three for anything that has a 1 or nothing and delete the whole row.

What I want to do is send this macro/Add In to other users. The way I made my Add In was i created a new blank workbook, pasted my code into the VB editor for sheet 1 of the new blank workbook, saved it as an .xla file.

Did I do something wrong?

Thanks

 

[Richard Schollar]

Can you not access your add-in macro by going Tools>Macro>Macros and selecting it?

 

[bdunk]

Add Ins

No, It is not displayed in the macro list. Is there a way to apply my Add In to my Personal.xls file. The macros I see are all for the Personal.xls file.

Bdunk

 

[Jay Petrulis]

Macros within an add-in file are not viewable in the Tools>Macro>Macros view. The most common way to run them is to have an option on either an existing toolbar or add a new one.

This should be done when the add-in is loaded (Workbook_Open or Autpen events) and should be deleted if the add-in is uninstalled.