Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change worksheet direction from right to left | New Users to Excel | |||
change direction worksheet excel 2007 right to left | Excel Discussion (Misc queries) | |||
Change worksheet direction from right to left | Setting up and Configuration of Excel | |||
How do I change the worksheet or workbook direction | Excel Discussion (Misc queries) | |||
HOW I CAN CHANGE TEXT DIRECTION FROM DOWN TO UP | Excel Discussion (Misc queries) |