How to change worksheet direction
 

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

Sorry about my English...

Asa

--
Asaf
-----------------------------------------------------------------------
Asaff's Profile: http://www.excelforum.com/member.php...fo&userid=1460
View this thread: http://www.excelforum.com/showthread.php?threadid=26233

How to change worksheet direction
 

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

How to change worksheet direction
 

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

How to change worksheet direction
 

Hi Asaff

You can open a new workbook
keep one worksheet and delete the others
Change the setting in the VBA editor (DisplayRightToLeft property in the sheet module )
Save this workbook with one sheet as a template

When you right click on your worksheet tabs you can use Insert to add a
worksheet to your workbook with this setting.





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


"Asaff" wrote in message ...

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


--
Asaff
------------------------------------------------------------------------
Asaff's Profile: http://www.excelforum.com/member.php...o&userid=14609
View this thread: http://www.excelforum.com/showthread...hreadid=262338

How to change worksheet direction
 

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

How to change worksheet direction
 

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

How to change worksheet direction
 

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

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