I believe you may be restricted because of this caution in the help:

This property can be set only when right to left language support has been
installed and selected.



This may be why it isn't visible in Tools=Options as well. (or not, I can't
say <g)

--

Regards,

Tom Ogilvy



"Ron de Bruin" wrote in message
...
Hi keepITcool

i dont see it in xl97, but it's there in xlXP. (dont know for xl2000)

In 2000 there is a DisplayRightToLeft property in the sheet module but
you can't toggle it.(you can't change it)
And you don't see it in ToolsOptions like in 2002/2003


--
Regards Ron de Bruin
http://www.rondebruin.nl


"keepITcool" wrote in message
...

First time i've tried that :)

with worksheets.add
.name = "International"
.displayRightToLeft = False
end with

the DisplayRightToLeft is a property of the worksheet class, so you can
also change it for existing sheets. (in the VBE/Properties window just
toggle it in the properties of the worksheet)

i dont see it in xl97, but it's there in xlXP. (dont know for xl2000)

but I must add that mixing these modes inside 1 workbook makes
navigating between sheets very strange :)



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Asaff wrote:


I work whit exell 2003 that support Hebrew, the default direction is
right to left (rtl)
how can I create new worksheet that will be Left to right?

Sorry about my English...

Asaf