Share via

Problem with using Application.Dialogs(xlDialogPrint).Show in Excel MAC 2016

Anonymous
2017-09-17T11:59:37+00:00

Hello,

when I use the VBA Code Application.Dialogs(xlDialogPrint).Show in Excel MAC 2016 (latest Version) the decimal and thousand separators are changed from "german" to "us". By using the print dialog everything works fine. Any Ideas?

thanks in adevance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2017-09-18T06:44:10+00:00

    Hello Yoga,

    the Problem is not using the VBA Code, it works fine. But the cell formatting of the document changes when using the VBA xlDialogPrint code. This seems to be a bug in Excel 2016 MAC.

    Regards

    Ralf

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2017-09-18T01:37:00+00:00

    Hi RalfNyenhuis,

    From your description, you are having problems with the VBA code when you using it in Excel 2016 for Mac. We will help you move the question to Office > Excel> Microsoft Office Programming > Office 2016 for you to get expert help.

    Thanks,

    Yoga

    Was this answer helpful?

    0 comments No comments