(The module is Module3, and it is dedicated to code having to do with the Ribbon.) I wrap the variable definition code (along with the rest of the code in this module) in an #IF statement, like so: #If Not Mac or MAC_OFFICE_VERSION >=15 Then I am defining a variable of type IRibbonUI for use inside a standard module. I thought I had it set that it would not compile the code if running on this version of Excel, but it doesn't seem to be working. However, there is a line in my code that is giving me a compile error on that version of Excel. I know that a custom Ribbon tab is not possible in Excel 2011. Sometimes, depending on what the user does, I want the text of the ribbon buttons to change. One platform on the Mac I want it to run on is Excel 2011. ![]() ![]() I am creating an Excel Macro-Enabled Workbook for both Windows & Mac.
0 Comments
Leave a Reply. |