
Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
Hi Ron,
Thank you for your kind assistance.
yes I had enabled Arabic,i.e. right to left language as a second language on
my computer.
You had mentioned in the link you sent me " The default sheet direction for
Excel you can change with this code line
Application.DefaultSheetDirection = xlLTR 'or use xlRTL"
Would you please explain how can I do that in easy steps please.
mehro@eim.ae is my email address.
I appreciate your help
> Hi Ahmad
>
[quoted text clipped - 8 lines]
> > Kindly email me your suggestions on mehro@eim.ae
> > Thanks
Ron de Bruin - 10 Apr 2008 20:24 GMT
Hi Ahmad
Open a new workbook
Alt F11
Use Insert module in the VBA editor
Copy this in the module
Sub test()
Application.DefaultSheetDirection = xlLTR 'or use xlRTL"
MsgBox "Ready"
End Sub
With your curser in this macro press F5 to run ther macro
Now close the file without saving

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
> Hi Ron,
> Thank you for your kind assistance.
[quoted text clipped - 19 lines]
>> > Kindly email me your suggestions on mehro@eim.ae
>> > Thanks
Ahmad Mahran - 10 Apr 2008 20:55 GMT
Thanks Ron it worked.
Now I have my A column on the left, but I have two pages!!
how can we have only one page at start up?
Sorry man.
Ahmad
> Hi Ahmad
>
[quoted text clipped - 35 lines]
> >> > Kindly email me your suggestions on mehro@eim.ae
> >> > Thanks
Ron de Bruin - 10 Apr 2008 21:15 GMT
With two pages you mean two sheets when you open a new workbook

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
> Thanks Ron it worked.
> Now I have my A column on the left, but I have two pages!!
[quoted text clipped - 41 lines]
>> >> > Kindly email me your suggestions on mehro@eim.ae
>> >> > Thanks
Ahmad Mahran - 10 Apr 2008 22:03 GMT
yes.
two pages
> With two pages you mean two sheets when you open a new workbook
>
[quoted text clipped - 43 lines]
> >> >> > Kindly email me your suggestions on mehro@eim.ae
> >> >> > Thanks
Ron de Bruin - 10 Apr 2008 22:13 GMT
Hi Ahmad
Office Button>Excel options
Popular
Change "Include this many sheets:" to 1

Signature
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
> yes.
> two pages
[quoted text clipped - 46 lines]
>> >> >> > Kindly email me your suggestions on mehro@eim.ae
>> >> >> > Thanks
Ahmad Mahran - 11 Apr 2008 05:59 GMT
thanks a lot man
> Hi Ahmad
>
[quoted text clipped - 53 lines]
> >> >> >> > Kindly email me your suggestions on mehro@eim.ae
> >> >> >> > Thanks