charlie rowe

[Guest]

Occasionally, when I open an Excel file produced by another program
(e.g. Quickbooks), the column headers (A,B,C,...) run from right to left,
rather than left to right. And the row headers run down the right side of
the window rather than the left side. The scrollbars, etc., are also
reversed.
Any ideas why this happens? And, can you even re-position all these
things with VBA?
(If I copy and paste the data into a new workbook, I can then have the
data in a window that looks normal to me.)

Thanks,
Charlie Rowe

 

[David Biddulph]

Occasionally, when I open an Excel file produced by another program
(e.g. Quickbooks), the column headers (A,B,C,...) run from right to left,
rather than left to right. And the row headers run down the right side of
the window rather than the left side. The scrollbars, etc., are also
reversed.

Tools/ Options/ International/ right to left