In the MY MACROS tab, click the arrow for Macro List 1 drop down.Before you add the new macro, take a look at the current list: Get Ready to Add a Macroįor the first change, you will add another macro to Macro List 1. You can delete items from the worksheet lists, add new items, or change the existing macro names. The drop down lists are flexible, and will show all the items from the Macro List tables on the worksheet. In Macro List 1, you can see the ToggleGridlines macro, which you tested earlier. They contain the macro names for each of the drop down lists. It displays the image named WebGoBack.Īt the right, there are two Excel tables. It has the label "Hello Message", and runs the HelloMsg macro. In the second row, you can see the settings for Btn2. The Button information is stored in the table at the left side of the Admin sheet. To run different macros from the MY MACROS Ribbon tab, you will make changes on the Admin sheet in the sample workbook. If gridlines were on, it hides the gridlines.Īt the right of the MY MACROS tab, there are two command buttons for Excel Help.Ĭlick those buttons to go to the main page of my Contextures website, or to this instruction page for the custom MY MACROS tab.If gridlines were off, it shows the gridlines.That runs the ToggleGridlines macro, which changes the gridlines setting on the active worksheet. In the centre of the MY MACROS tab, there are 2 drop down lists - Macro List 1, and Macro List 2.Ĭlick the drop down arrow on Macro List 1, and in the drop down menu, click ToggleGridlines. That button runs a macro that shows a message box, with the word, "Hello".Ĭlick the OK button to close the message box. To test the macros, click the Hello Message button, at the left side of the MY MACROS tab. There are 10 buttons at the left, in 2 groups - Macro Buttons1 and Macro Buttons2. The custom tab has buttons and drop down lists, described below. Open the Excel file, and be sure to enable macros.Īfter you open the My Macros sample file, you should see a custom tab on the Excel Ribbon - MY MACROS.Next, unzip the downloaded folder, and store the Excel file in a folder on your computer.Right-click on the zipped file, click Properties, and then check the box to Unblock. Due to Microsoft security settings, you might need to unblock the downloaded file.First, go to the Download section below, and get the My Macros sample file.Video Timelineįollow these steps to get started with the Custom Ribbon tab. Written instructions are below the video. To see how to add your macros to the ribbon, get the sample workbook, and watch this video. NOTE: If you want to create your own custom tabs from scratch, see these pages: You do NOT need to go into the Ribbon CustomUI, or do any Ribbon programming. To add your macros, you'll make changes on the worksheet. Later, you can remove the sample macros, and add your own macros to the file. The sample file also contains sample macros, to demonstrate how the custom tab works. You can choose label text, button images, and which macro each button should run. The My Macros sample file has a custom tab with 10 buttons, and 2 drop down lists. In this tutorial, you'll see how to add your macros to a custom tab on the Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |