How do I add a macro button to the Excel ribbon when I start a new program? I generate files which have the same format and would like to either add macro buttons to the Excel ribbon or develop an Add-In that will simplify running the same macro.
Any ideas how best to accomplish this?
Thank you.
Jim15
What version of Excel are you using?
(You should update your profile to include that.)
I did update.
- Create your macro in a Module (like Module1, but not a Worksheet module) in your PERSONAL.xlsb file. Make it a Public Sub.
- Right-click anywhere on the Ribbon, and select Customize the Ribbon.
- On the right, create a new Tab and then create a Group under it, or create a new Group within an existing Tab.
- On the left side, select Macros from the top dropdown then you will see a list of your public macros.
- Select the one you want and click Add to add it to your selected Group.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks