This script works fine if I run it from scripteditor, but not embedded in VBA.

Debug.Print toggleRibbon to check format (use of double quotes, etc.).

If you look for answers on here containing the word osascript you will see that you can run Applescript using osascript.

Now, in VBA you can call Shell() so you should be able to do Shell(XXX) where XXX is either an osascript command or a bash script that contains the osascript command with the Applescript stuff you already have.

Fairly similar example here stackoverflow.coma21984032836621.

The string must contain the Applescript (including the line breaks).

It could be that you didnt escape the double quotes correctly - so add that into your question.

However, trying to get these properties from application document, window, workbook, basic window,.always return missing value.

I guess it is not properly handle by Microsoft for Applescript.

Script bellow simulates the click of the item 4 (Ribbon) of the menu 5 (View) of the main menu bar.

Of course Excel must be activate (front most) before that simulation.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Not the answer youre looking for Browse other questions tagged excel vba macos applescript or ask your own question.

Excel For Mac Ribbon