Dec 17, 2018 The only reason I still use MS Office is to continue supporting my VBA products. I need the developer ribbon option enabled: at this point, Excel drops me into edit mode for sheet objects, and there is no visible way to exit edit mode in order to run the code associated with those objects.
I know a workaround, but you need to be able to edit the VBA Code in Windows first and save your Macro-enabled.xlsm spreadsheet as a.xlam file. To create the ribbon, the method relies on a 3rd party software called Office Ribbon Editor. Then, go to your Mac computer and install the addin from Tools - Addins menu. Part A: Create a custom Ribbon tab for Microsoft Excel in Windows Here are the detailed steps: Install Office Ribbon Editor.
You'd need to download the latest.NET Framework pack during the install process. Once installed, use Run as Administrator to open the Office Ribbon Editor. Create a new Excel 2010 Spreadsheet. Here, you'll need to specify the output file. Choose Excel Macro Enabled Workbook (.xlsm) Add a Custom UI for Office 2010 using Document Explorer pane (at the right). Use the following code template for the Custom UI content. Edit accordingly.
Code snippet: Save the changes and close the application. Now, open the.xlsm file using Microsoft Excel for Windows.
Enable the Developers tab in the Ribbon. Click VBA Code to view the source code and add a new Module. Then, create a Sub that will be executed when the user clicks the button. For the code I specified above, you'd need to create Sub ExportImages. Finally, close the VBA editor and click File - Save As to save your spreadsheet as an Excel Add-in (.xlam). Part B: Install the add-in on Mac Go to your Mac and open Microsoft Excel for Mac. Go to Tools - Add-ins and browse for the xlam file you created using Windows.
Once the add-in is enabled you should be able to see the custom UI tab in the Ribbon. Misc: The process also works for other Microsoft Office programs: Excel, PowerPoint and Word. I didn't test the approach for Outlook add-ins. In fact, I have used this approach to make an add-in for Mac and Windows that exports all the presentation slides in PowerPoint to JPG images, with a single click. This helped me to save valuable time (for years) while uploading the free PowerPoint templates to my site.
See solution in other versions of Excel:. You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor.
First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc. To display the Developer tab, click on Preferences under the Excel menu at the top of the screen. When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and Privacy section. In the Customize section, check Developer in the list of tabs to show. Then click on the OK button.
Select the Developer tab from the toolbar at the top of the screen. Then click on the Editor option in the Visual Basic group. Now the Microsoft Visual Basic editor should appear and you can view your VBA code.