Excel 2011 (MAC) spelling options using vba

[ashish.rathi123]

I am trying to change the spelling options settings through macro and it does not seem to work for excel 2011 (MAC version). I have tried and tested the command below on excel 2013 (windows) and it works. Please tell me how to make it work for excel 2011.

Code -

Please Login or Register  to view this content.

Regards,
Ashish

[Izandol]

These options are not present in Mac Excel, therefore you may not set them in the code.

[ashish.rathi123]

Thanks a lot. So, will spell check produce different results in excel 2011 version (MAC) and excel 2013 version(Windows) because of different settings. These settings have been set in excel 2013 version but if they don't exist then the spell check might mark different words as errors.

Like if ignore caps setting is enabled, then some word like FICO will not be be counted as a wrong spelling but will the same result be shown by a MAC? Or is there any way to get these settings for spell check in MAC too?

Regards,
Ashish

[Izandol]

I am not certain but I think that these options are controlled by the Word preferences. The values you have shown will be the defaults but I do not think you may test them directly from Excel - you must automate Word.