ActiveSheet.EnableFormatConditionsCalculation Not Supported in VBA for Excel 2011 on the Mac

Question

"ActiveSheet.EnableFormatConditionsCalculation = True" is not supported in VBA for Excel 2011 on the Mac.  When I run this code on a Mac install of Excel I get the error message 'Object does  not support this property or method." 

Is there alternate code that does the same thing?  Even better if it works on Mac and Windows both. 

Thanks!

Jeff Travis

Answer 1

AFAIK, MacXL doesn't support turning off conditional formatting calculation, so while there's no alternate code for Mac VBA, it's also unnecessary.

You could use conditional compilation to keep the line from executing in MacVBA, e.g.:

#If Mac Then

'Conditional Format Calculation always on for Mac

#Else

ActiveSheet.EnableFormatConditionsCalculation = True

#End If

Thanks for your reply.

That's essentially what I'm doing now.  The  spreadsheet has the ability to detect, via user entry of a root path string, whether it is installed on Windows or Mac.  So if it detects Mac, I just have to code around the statement in VBA. 

A little background as to the motivation for the question, in case anyone has any other ideas:  a particular worksheet in the workbook has some conditional formatting that depends on a relatively long chain of condition calculations.  Earlier in the development I inquired as to whether there was a way to ensure the formatting would update without doing an "Application.CalculateFullRebuild".  Toggling the conditional format calculation enable off and back on was suggested as an alternate approach, and it seems to work fairly well. 

I have to admit I haven't done enough testing of the spreadsheet on the Mac to know for sure whether either statement is actually necessary to ensure conditional format update.  That is now on my to-do list.  I guess if the formats are not updating properly on the Mac I can use Application.CalculateFullRebuild for a Mac install and live with the slightly reduced performance.

Jeff

Answer 2

AFAIK, MacXL doesn't support turning off conditional formatting calculation, so while there's no alternate code for Mac VBA, it's also unnecessary.

You could use conditional compilation to keep the line from executing in MacVBA, e.g.:

#If Mac Then

'Conditional Format Calculation always on for Mac

#Else

ActiveSheet.EnableFormatConditionsCalculation = True

#End If