I'll post it as an answer since it won't fit into the comment section. The step-through highlights the name of the sub as the line that is causing the error: Sub UpdateOptions()ĭoes anyone know why this is happening? It doesn't make any sense to me. When I step through the code, the error happens when UpdateOptions is first called by another sub. #If Not Mac or MAC_OFFICE_VERSION >=15 Then I have an IF statement that makes sure it is not, like so: Sub UpdateOptions() *ChangeRibbon should never actually be run on Excel 2011.
#EXCEL 2011 FOR MAC CODE#
I don't understand why, because as far as I understand, the code in that module shouldn't be compiling at run-time. However, when I am running a sub (let's call it "UpdateOptions", and it is in Module1) that calls a sub that changes the Ribbon (let's call that one "ChangeRibbon", which is in Module3*), I get a compile error on the ribbonUI line: User-defined type not defined When the workbook opens, I do not get any errors. This means it should not compile at run-time on Excel 2011. (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 kommentar(er)
