If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CTRL+TAB
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? |
#2
|
|||
|
|||
CTRL+TAB
If your two worksheets are in separate windows Ctrl +Tab will cycle between
them To navigate through sheets of a workbook use Ctrl + PageUp and PageDown To change the behaviour of your Ctrl + Tab would require re-mapping your keyboard. Gord Dibben MS Excel MVP On Fri, 4 Dec 2009 12:52:01 -0800, Rodrigo Argento (Brasil) Rodrigo Argento 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? |
#3
|
|||
|
|||
CTRL+TAB
Hi Rodrigo,
For a list of Excel keyboard shortcuts, which is a lot easier to read than trying to work with the one segment at a time in HELP, see Shortcut Keys in Excel 2000 through Excel 2007 http://www.mvps.org/dmcritchie/excel/shortx2k.htm FWIW, you really do not want to change keyboard shortcuts in most cases because they are basically the same shortcuts used in other applications and by others using Excel. For instance here is a comparison of browser keyboard shortcuts on Windows and you will see that the shortcuts for tabs are very similar to Excel because Excel had tabs before browsers so that is what people were used to. http://www.mvps.org/dmcritchie/firefox/keyboard.htm -- HTH, David McRitchie My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Gord Dibben" wrote... If your two worksheets are in separate windows Ctrl +Tab will cycle between them To navigate through sheets of a workbook use Ctrl + PageUp and PageDown To change the behaviour of your Ctrl + Tab would require re-mapping your keyboard. Gord Dibben MS Excel MVP Rodrigo Argento (Brasil) wrote... 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? |
#4
|
|||
|
|||
CTRL+TAB
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. It’ll 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 don’t 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? |
Thread Tools | |
Display Modes | |
|
|