Application.CommandBars.ExecuteMso equivalent on a MAC

Question

Hello Everyone,

Please forgive me if this is not the appropriate forum for this question and please point to the right one, but does anyone know what the MAC equivalents are for the following VBA code?

Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")

and

Application.CommandBars.ExecuteMso ("ViewCustomViews")

Greatly appreciate your help.

Regards,

John

Answer 1

This is the right forum. However you need to be a bit more specific as to exactly what you are trying to do, and with what version of Excel. For example, in Excel 2016 for the Mac it is not possible to modify command bars or call command bar commands.

Answer 2

You wrote: "Recording a macro yields no code. ... There is nothing in the MAC version that is comparable to Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")."

I had written: "In Mac Excel 2011 a recorded macro for selecting File > Print yields

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1"

Answer 3

Hi Bob,

Thanks for the quick reply.  All I'm trying to do is to bring up the Custom Views box or the Print window with macros assigned to macro buttons on the Mac version of Excel.  I figured out how to do it on the Windows version of Excel, however, not being familiar with the MAC environment I'm not sure if it can be done.  Recording a macro yields no code.  Your answer actually answers my question.  There is nothing in the MAC version that is comparable to Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint").  Again, thank you.

John

Answer 4

In Windows Excel 2010 your first line of code performs the equivalent of choosing File > Print.

In Mac Excel 2011 a recorded macro for selecting File > Print yields

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1

In Windows Excel 2010 your second line of code shows the Custom Views dialog box.

In Mac Excel 2011 a recorded macro for selecting View > Custom Views by itself does not yield any code.

In Mac Excel 2011 a recorded macro for selecting View > Custom Views > Add ... yields

ActiveWorkbook.CustomViews.Add ViewName:="JohnSur", PrintSettings:=True, RowColSettings:=True

Answer 5

You may also post your query in link and check if you are able to find some information.

https://social.technet.microsoft.com/Forums/en-US/home?forum=Office2016forMac&filter=alltypes&sort=lastpostdesc