A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

CTRL+TAB



 
 
Thread Tools Display Modes
  #1  
Old December 4th, 2009, 09:52 PM posted to microsoft.public.excel.setup
Rodrigo Argento (Brasil)
external usenet poster
 
Posts: 1
Default 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  
Old December 4th, 2009, 10:19 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old December 8th, 2009, 02:03 PM posted to microsoft.public.excel.setup
David McRitchie
external usenet poster
 
Posts: 606
Default 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  
Old January 14th, 2010, 09:47 PM posted to microsoft.public.excel.setup
daemonbarber
external usenet poster
 
Posts: 1
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.