Two bits of Code in VBA (ALT+F11 to view):


'Place this in the code for you PERSONAL.XLS 'ThisWorkbook'
Private Sub Workbook_Open()
Application.OnKey "^{TAB}", "nextTab"
Application.OnKey "^+{TAB}", "prevTab"
End Sub

'Add these to a module in the PERSONAL.XLS workbook
Sub nextTab()
If ActiveSheet.Index = Sheets.Count Then
Application.ActiveWorkbook.Sheets(1).Select
Else
Application.ActiveWorkbook.Sheets(ActiveSheet.Inde x + 1).Select
End If
End Sub

Sub prevTab()
If ActiveSheet.Index = 1 Then
Application.ActiveWorkbook.Sheets(Sheets.Count).Se lect
Else
Application.ActiveWorkbook.Sheets(ActiveSheet.Inde x - 1).Select
End If
End Sub

And there you go. Itll remap your Ctrl+Tab and your Ctrl+Shift+Tab to move
forward or backwards through tabs, wrapping around when it reaches the end.

If you dont have a PERSONAL.XLS workbook, just record a blank macro and
tell it to save to your Personal Workbook.

"Rodrigo Argento (Brasil)" wrote:

Hello guys,

Let me see if you can help me...

How do I do to change CONFIGURATION of CTRL+TAB to change from one WORKSHEET
to another?