Hi there

I'm a bit desperate and hope to get some hints here:
I do have an Excel file with some VBA macros running (the used filetype is .xlsm) which was originally created in an Excel 2010 environment under Windows. The Excel file now should not only be used under Windows but also under Mac (in fact I don't even have control or knowledge about the exact Excel versions being used).

One thing the very simple macros do, is setting a printing area for the active sheet and then open up the printing preview.

In the MAC version of Excel however the printing process is directly started and I haven't managed to find a way to prevent that. That's the main problem I really need to solve.
Not as important: it would also nice, if I'd find a way to call the printing dialogue after the printing area is set (as there doesn't seem to be an equivalent to the printing preview).

Here is an example of the code I'm using:
Sub MyAreaToSelect()
    ActiveSheet.PageSetup.PrintArea = "$A$69:$AF$130"
    ActiveWindow.SelectedSheets.PrintPreview
End Sub
I also experimented with other stuff like
Application.Dialogs(xlDialogPrint).Show
but didn't succeed so far.

I really hope someone can help.

Thanks in advance,
thala