#1   Report Post  
Old December 4th 09, 09:52 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
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   Report Post  
Old December 4th 09, 10:19 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
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   Report Post  
Old December 8th 09, 02:03 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 903
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   Report Post  
Old January 14th 10, 09:47 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Ctrl-C, ctrl-V work in Office 2007 hj Excel Discussion (Misc queries) 1 June 23rd 09 01:09 PM
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets DrDave Excel Discussion (Misc queries) 1 July 28th 08 04:12 AM
use CTRL key inside a macro IE CTRL + ; Date Less Excel Worksheet Functions 1 April 14th 08 11:58 PM
Anyone having Ctrl+C / Ctrl+V problems in E2007? Krzysztof Kruszynski Excel Discussion (Misc queries) 1 June 13th 07 01:41 PM
How to forbid ctrl+c and ctrl+X in sheet? GR Setting up and Configuration of Excel 2 December 24th 06 04:39 AM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017