QUICK DEBUG: why doesn't this work in Excel 2011 for Mac?

**monahan00** · 11-23-2014, 10:18 PM

Hi everyone. Long time reader, first time poster.

I am pretty good with VBA now and familiar with some Mac/PC issues (and Ron DeBruin's site). I know the ribbon is difficult to customize in Excel 2011 for Mac, so I created a variable so that the code would only execute on a PC. Yet I receive a "Compile Error: Method or data member not found" message.

Please Login or Register  to view this content.

The '.ExecuteMso' portion is highlighted in blue, and the Private Sub MacroName line is highlighted in yellow. "TestMac" accurately determines what operating system is in place, but I put in a breakpoint before it and it doesn't even get to that. I don't understand why. I'm guessing Excel reads the whole code first to compile it and then again in runtime or something?

Can someone explain this to me? The goal is just to minimize the ribbon when the macro is run on a PC.

Thanks,

Jeff

**LJMetzger** · 11-24-2014, 08:43 AM

Hi Jeff,

I was unable to test the routine because I only have Excel 2003 and the ".ExecuteMso" command is not supported in Excel 2003.

However your code will probably fail because when you run "TestMac" there is no return value.

Please Login or Register  to view this content.

Your code should probably look like this:

Please Login or Register  to view this content.

Please note that 'Option Explicit' should be at the top of your module and appear only once at the top of each module. To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis