How to change worksheet direction

[Asaff]

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

 

[keepITcool]

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 >

 

[Ron de Bruin]

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 Tools>Options like in 2002/2003

 

[Ron de Bruin]

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.

 

[Tom Ogilvy]

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]

Hi Tom

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

 

[Tom Ogilvy]

Maybe you have right to left language support installed in xl2002

 

[Ron de Bruin]

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