如何将宏分配给自定义菜单VBA?

I'm trying to create a custom menu with buttons that have macros assign to them so that the end user doesn't need to do anything except run it. I have the installer as add in and code in ThisWorkbook that will run on open event everything runs perfectly but the problem is the buttons don't work except for the RemoveButtons that removes the add in altogether. Maybe i'm doing something wrong here. The code is in a standard module. I'm trying to create a custom menu with buttons