Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

xlsm macro available in xls

Posted on 2014-04-15
2
370 Views
Last Modified: 2014-04-16
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
0
Comment
Question by:TLANGI
  • 2
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 40003052
If the buttons on the ribbon are part of the Custom UI part of the file, then any Excel 2007 user should see those buttons when they open the file. Should that be the case, store the Excel file in the XLSTART folder in the new user's computer. The workbook will then be opened automatically whenever Excel launches, and the macros will always be available.

It is also possible to store the macros in a Personal.xlsb macro workbook, once again in the new user's XLSTART folder. If the user doesn't have one, the easy way to get one is:
1.  Record a new macro, making sure to choose to store the macro in "Personal macro workbook" in the first step of the macro recording wizard
2.  The macro doesn't need to do anything, so you can quit recording as soon as you start
3.  Open the .xlsm file that contains the macros
4.  ALT +F11 to open the VBA Editor
5.  I assume the macros are in Module1 in the .xlsm file. If so, drag Module1 from the .xlsm file into Personal.xlsb
6.  Quit Excel, making sure to save Personal.xlsb when prompted

To add an icon to the ribbon:
1.  Rightclick the ribbon and choose "Customize the ribbon..."
2.  In the "Choose commands from" field on the left, select Macros
3.  In the resulting pane on the right, choose the menu you want to add the icons to, then click "New Group"
4.  Choose a macro, then click the Add>> button between the two panes
5.  Repeat for the other macro
0
 
LVL 81

Expert Comment

by:byundt
ID: 40003055
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
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question