Firstly, I am not a programmer... just a 'winger'..
I have built several macros for the Excel 2010 PC version. Placed them in an ADD-IN for ease of distribution, and tied them to buttons on the QAT (Quick Access Toolbar).
Now, one of the folks I did this for is moving to MAC and using Excel for mac 2011. I am having extreme difficulty finding how to put any kind of button on the toolbars that ties to a macro in the add-in.
I have copied the add-in to the default location for them in mac. Excel can see them when I open 'editor' with the 'developer'. But I can find no way to tie them to a button on the toolbars. I can create a toolbar and assign a button, but when trying to link it to a macro, nothing shows up in the macros list ???
any help would be appreciated.
I have built several macros for the Excel 2010 PC version. Placed them in an ADD-IN for ease of distribution, and tied them to buttons on the QAT (Quick Access Toolbar).
Now, one of the folks I did this for is moving to MAC and using Excel for mac 2011. I am having extreme difficulty finding how to put any kind of button on the toolbars that ties to a macro in the add-in.
I have copied the add-in to the default location for them in mac. Excel can see them when I open 'editor' with the 'developer'. But I can find no way to tie them to a button on the toolbars. I can create a toolbar and assign a button, but when trying to link it to a macro, nothing shows up in the macros list ???
any help would be appreciated.