View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default How to change worksheet direction

Hi Tom

Not that I know of?
But there are more things that i don't know<g

Office 2003 is also doing this correct (dutch and English version)
But I always do a full install if I install Office

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


"Tom Ogilvy" wrote in message ...
Maybe you have right to left language support installed in xl2002

--
Regards,
Tom Ogilvy

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

The Excel 2002 help say the same and it is working in this version.
(Both English versions)

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


"Tom Ogilvy" wrote in message

...
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