TLANGI
asked on
xlsm macro available in xls
Hi,
i am overtaking a project from someone else who left the company. i have a xlsm file with 2 macros in it.
2 other users do have 2 lil buttons/icons in their ribbon to execute that macro.
now i have a new hire and i dont know how to bring that macro or that xlsm file into their excel so that i can customize the ribbon to.
how do i link excel to that maco in that xlsm file?
thank you
i am overtaking a project from someone else who left the company. i have a xlsm file with 2 macros in it.
2 other users do have 2 lil buttons/icons in their ribbon to execute that macro.
now i have a new hire and i dont know how to bring that macro or that xlsm file into their excel so that i can customize the ribbon to.
how do i link excel to that maco in that xlsm file?
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Storing a custom icon in the ribbon by means of Custom UI additions to the .xlsm file is fairly fiddly. Microsoft Excel MVP Ron de Bruin has a series of webpages that discuss the topic in detail. The index page for those is at http://www.rondebruin.nl/win/section2.htm