ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   charlie rowe (https://www.excelbanter.com/excel-discussion-misc-queries/93535-charlie-rowe.html)

Charlie Rowe

charlie rowe
 
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

charlie rowe
 
"Charlie Rowe" wrote in message
...
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
--
David Biddulph




All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com