can't see the vba code in a xlsm file when opened in excel for mac

Question

When I open an xlsm file I can see the vba code in module 1, as shown below

But when I open the same xlsm file in excel for mac, firstly the "module 1" tag is shown as garbled text, secondly the vba code doesn't displayed at all, as shown below

I have reinsatalled the excel so I am sure it's in the newest version (16.76).

Answer 1

Hi,

This seems to be something unusual.

Try the following troubleshooting methods-

1. Enable macros in your Excel for Mac if you haven't already.
2. Try opening a different XLSM file on your Mac to check if the issue is with this file only or if is it with your Excel for Mac.
3. Some VBA code that works on Windows may not work on Mac due to platform differences. Ensure that the XLMS file is not using VBA features or code that are incompatible with Excel for Mac.
4. Run a thorough virus and malware scan on your Mac to rule out any security-related issues.

Best Regards.

Answer 2

Before opened in Mac,please remove all Chinese Charaters in the VBA codes because your mac is in English VBA environment.