Changing the thousands separator in VBA

Re: Comma decimal separator dot

Quote from B.W.B.;773603

[ATTACH=CONFIG]69619[/ATTACH]

New wbook. https://1drv.ms/x/s!ArVOOVnFRGX4hJJaQHRVkRUrs4Pi5Q
I hope someone will know how to tackle this weird PrintPreview problem

And, i forgot to mention, also posted: https://answers.microsoft.com/…cf-4e95-b478-51a23fd44bf2

Re: Comma decimal separator dot

Quote from B.W.B.;776741

I figured out after three months. Problem is in PrintPreview, but WHYYY MICROSOFT, WHY!

Code

'  In case there is no printing device:
         On Error Resume Next
         Application.Dialogs(xlDialogPrinterSetup).Show
         Selection.PrintOut Preview:=True

When i set Selection.PrintOut Preview:=False everything is fine, no error.
But, why! I really need print preview

Bump :([/QUOTE]

YES YES YES YES YES YESSSSSS!
PROBLEM SOLED! Thank You: heinziburli

https://answers.microsoft.com/en-us/...1-ad96face8164

The answer is: Application.CommandBars.ExecuteMso "FilePrintPreview"