Excel 2016 Add-in doesn't show...

[Darkside61]

[FONT=&quot]Hi guys.
I have developed 2 macros in Excel to remove blank lines and columns from an Excel sheet.
I've save the two files as Add-in (*.xlam) in the default path for Add-in im my computer ("C:\Users\Adriano\AppData\Roaming\Microsoft\AddIns")[/FONT]
[FONT=&quot]I went to File/Options/Add-in/ and activate them.[/FONT]
[FONT=&quot]When I open Excel the Add-in pane doesn't show in the Ribon.
Am I doing abything wrong?[/FONT]
[FONT=&quot]Any help will be welcome...[/FONT]
[FONT=&quot]
Thanks[/FONT]
[FONT=&quot]Adriano[/FONT]

 

[AddinBox_Tsunoda]

Hi.

> I've save the two files as Add-in (*.xlam)
> I went to File/Options/Add-in/ and activate them.
> When I open Excel the Add-in pane doesn't show in the Ribon.

Do the two add-in books have menus by CommandBar (menu method before Excel2003)?
Is the add-in menu not displayed in "Add-in Tab"?
Is the add-in menu not displayed even after restarting Excel after registering an add-in?

Please refer to the explanation below and review the execution procedure of add-in registration.
http://addinbox.sakura.ne.jp/Excel_Tips27E.htm

There are 2 types (Temporary and Permanent(Save)) in the menu by CommandBar.
--------------------------------------------------------
If it is a temporary type,
if you only restart Excel after registering an add-in,
you will surely see an add-in menu in Excel2013/2016.
--------------------------------------------------------
However, in the case of the permanent type,
Even if you restart Excel, the add-in menu may not be displayed in Excel2013/2016.
In order to display the add-in menu,
Please register as add-in according to the procedure presented in section 6-1 of the link site above.

 

[Darkside61]

Thank you for your fast response AddinBox_Tsunoda.

The Add-in TAB is not displayed in Excel.
I've tried to Select the AnalysisToolPak and the Add-in Tab doesn't show either.

Do you have any clue?

Thanks.
Adriano

Hi.

> I've save the two files as Add-in (*.xlam)
> I went to File/Options/Add-in/ and activate them.
> When I open Excel the Add-in pane doesn't show in the Ribon.

Do the two add-in books have menus by CommandBar (menu method before Excel2003)?
Is the add-in menu not displayed in "Add-in Tab"?
Is the add-in menu not displayed even after restarting Excel after registering an add-in?

Please refer to the explanation below and review the execution procedure of add-in registration.
CommandBar Menu & Add-in Tab with Add-in of Excel2013/2016.

There are 2 types (Temporary and Permanent(Save)) in the menu by CommandBar.
--------------------------------------------------------
If it is a temporary type,
if you only restart Excel after registering an add-in,
you will surely see an add-in menu in Excel2013/2016.
--------------------------------------------------------
However, in the case of the permanent type,
Even if you restart Excel, the add-in menu may not be displayed in Excel2013/2016.
In order to display the add-in menu,
Please register as add-in according to the procedure presented in section 6-1 of the link site above.

 

[MARK858]

Is your addins folder a trusted location?

 

[AddinBox_Tsunoda]

> I've tried to Select the AnalysisToolPak and the Add-in Tab doesn't show either.

In the case of AnalysisToolPak, it is incorporated as [ Data Analysis ] button on Data tab, not Add-in tab.

 

[Darkside61]

Hi Mark858.

Yes, my addins folder is in a trusted location.

Is your addins folder a trusted location?

 

[Darkside61]

Here is the code:

Option Explicit
Sub ApagarLinhasVazias()


Dim UltimaLinha As Long
Dim r As Long
Dim Counter As Long


Application.ScreenUpdating = False


UltimaLinha = ActiveSheet.UsedRange.Rows.Count + ActiveSheet.UsedRange.Rows(1).Row - 1


For r = UltimaLinha To 1 Step -1
If Application.WorksheetFunction.CountA(Rows(r)) = 0 Then
Rows(r).Delete
Counter = Counter + 1
End If
Next r


Range("a1").Select


Application.ScreenUpdating = True


MsgBox Counter & " linhas vazias apagada(s).", vbInformation, "Linhas vazias"


End Sub


and the other

Sub ApagarColunasVazias()
Dim x As Long


RowIni = 3
RowFim = 98
CountBlankRows = RowFim - RowIni + 1


With ActiveSheet
For x = .Cells.SpecialCells(xlCellTypeLastCell).Column To 1 Step -1
If WorksheetFunction.CountIf(Range(Cells(RowIni, x).Address _
& ":" & Cells(RowFim, x).Address), "") = CountBlankRows Then
ActiveSheet.Columns(x).Delete
End If


Next
End With


End Sub

Hi Mark858.

Yes, my addins folder is in a trusted location.

 

[AddinBox_Tsunoda]

> Here is the code:
> and the other
Is there only this macro code in your add-in workbook?

Are you misunderstanding
that "add-in tab appears when creating (registering) an add-in workbook" ?

The add-in tab is a place to store the menu by CommandBar
which is the menu construction function of Excel2003 and earlier.

Naturally, even if you create (register) an add-in workbook
that does not create a CommandBar menu, the add-in tab does not appear.

In addition, if a macro in normal workbook (xlsm) creates a CommandBar menu,
that menu is stored in the add-in tab.

For AnalysisToolPak, see #5.

 

[Darkside61]

AddinBox_Tsunoda,

If I understand correctly what you said, I need to insert a CommandBar menu in my two macros code in order to se themin the Add-in tab?

Thanks for your help.

Adriano

 

[AddinBox_Tsunoda]

In the normal workbook, you can not run the add-in workbook macro from "Developer tab / Macros" (it will not appear in the list).

Instead, you need to create a menu button in the add-in workbook to run the ApagarLinhasVazias / ApagarColunasVazias macro.

If you create that menu button with a CommandBar, it will appear in the Addin tab.