Add-in macros not showing up

[blindsaint]

I've made an xlam to save all my editing macros as an add-in. I've also confirmed that sheets with the add-in installed do have the add-in show up in the add-in tab, and also as a VB project when I press alt-f11. I also have the file location where the xlam saved as a trusted source. However when I press alt f8 I still do not see the add-in macros.

 

[OaklandJim]

From feeble memory...When you right-click on a button to specify the macro to call type in the name of the sub in the add-in. Like I said, from memory that should work for an installed add-in. By the way, do you see the add-in file listed in the VBA editor (Project Explorer)? If not then AFIK that indicates that the add-in is not installed.

 

[MARK858]

When you double click on one of the modules (for example SetBookCellCol) what code appears in the window

 

[blindsaint]

When you double click on one of the modules (for example SetBookCellCol) what code appears in the window

 

[blindsaint]

From feeble memory...When you right-click on a button to specify the macro to call type in the name of the sub in the add-in. Like I said, from memory that should work for an installed add-in. By the way, do you see the add-in file listed in the VBA editor (Project Explorer)? If not then AFIK that indicates that the add-in is not installed.

The 3rd picture shows that the exlam is in the editor

 

[OaklandJim]

Like I said, FOR ME, if I type the name of a sub that is in my add-in into the "Assign Macro" setting for a button it works (i.e., calls the sub in the add-in). Right click the button and type in the name of the sub that is in the add-in.

And, I called the same sub that is in the add-in from a normal sub in my .xlsm file just like any sub in the .xlsm workbook.

Sub Junk()

    Call BasicNameAdd_SheetLevel '<= call sub in installed addin.

End Sub

 

[MARK858]

However when I press alt f8 I still do not see the add-in macros.

You wouldn't normally see an add-in in the menu you get by pressing Alt + F8.
If you want it to run by clicking something just add it to your QAT by using the more commands option