change direction worksheet excel 2007 right to left

[bolbol]

In Excel 2003, it is possible to change a worksheet direction to
right-to-left language: Options, international, change direction for this
worksheet to right-to.lef and it is done.

The question is how to do this in Excel 2007?

 

[Ron de Bruin]

hi bolbol

See
http://www.rondebruin.nl/sheetdirection.htm

 

[CheekyB]

I can't find the location of the dialogue box which is shown on your tips
page. My sheet direction is also left to right but when I had the previous
version of Excel (running on Vista) there was a toggle button which said
right to left. This doesn't seem to exist anymore. I've checked the Excel
editing language in options and it is set to UK English and US English as my
two chosen languages.

Please can you help me out - this is driving me nuts.

Thanks
CB

 

[Ron de Bruin]

Use the code on my site for Excel 2007

 

[CheekyB]

Where do I find my PERSONAL.XLSB to put the code into? I don't know how to
use macros.

Thanks
CB

 

[Ron de Bruin]

See
http://www.rondebruin.nl/personal.htm

There is also a link on the web page

 

[Ron de Bruin]

See your other thread in Excel.Setup, please use one group

 

[CheekyB]

Thanks for that. It's sorted it out but how do I know save it as my default
template? At the moment it is save in my documents folder and I just open it
as a normal file.

CB