need shortcut key

[kwco]

pls need shortcut key for sheet right-to-left icon in
formatting bat

 

[David McRitchie]

What are you asking?

You can use Page Up and Page Dn keys to move up or
down a worksheet tab at a time. Don't know if that is what you
are looking for. What is a formatting bat ?

--

 

[Dana DeLouis]

I understand it to mean that he wants to assign a shortcut key for "sheet
right-to-left." In Excel 2003, it is under Tools | Options,. |
International Tab. It is under the Right-to-left setting. You can add a
customized Icon to the toolbar. It is called "Sheet Right-to-Left" and is
found under the Format commands near the button.
To make a shortcut key, it seems to me the best way would be to make a
macro, and than assign a shortcut key to that.

Macro might be something like this:

Sub DisplayRightToLeft_Toggle()
With ActiveSheet
.DisplayRightToLeft = Not .DisplayRightToLeft
End With
End Sub

For the OP, assigning a shortcut key is a little hard to find. Insert the
above macro. Then, go to the worksheet, and select Alt+ F8 to bring up the
Macro Box. Select your macro, then click "Options." This is where you
assign shortcut keys.

HTH
Dana DeLouis