I sometimes change a series of worksheet titles. Is there a keyboard shortcut to jump to the next TAB (not the next worksheet)? Or from a current worksheet to its own tab?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Jump to Worksheet TAB? (Keyboard Shortcut) (2000)
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Jump to Worksheet TAB? (Keyboard Shortcut) (2000)
- This topic has 17 replies, 6 voices, and was last updated 21 years, 4 months ago.
Viewing 4 reply threadsAuthorReplies-
WSunkamunka
AskWoody Lounger -
WSTal
AskWoody Lounger -
WSErrolv
AskWoody LoungerJanuary 23, 2004 at 3:44 am #772810Tal,
You can judge for your self between VBA and Macros. VBA is rooted in BASIC, so you’re not exactly replicating {keys}. Figure a simple task, like move a value from one cell to another, then activate the Macro Recorder (Tools>Macro>Record New Macro) and do the task.(You’ll need to make a name, and I suggest use a file you won’t need to save. Place the macro in that file – You’ll be asked for the location.) Next, use the keys and/or mouse to accomplish the task. Finally, keyboard shortcut Alt-F8 to see a list of (your 1) macro. Select it and click Edit. You will be looking at VBA code.
Compared to old style Macros, there’s lots more you can do to automate spreadsheets. It may take a bit to move up the learning curve (keep checking with the Lounge!), but soon you’ll shake the Macro dust off your shoes.
Errol
-
WSErrolv
AskWoody LoungerJanuary 23, 2004 at 3:44 am #772811Tal,
You can judge for your self between VBA and Macros. VBA is rooted in BASIC, so you’re not exactly replicating {keys}. Figure a simple task, like move a value from one cell to another, then activate the Macro Recorder (Tools>Macro>Record New Macro) and do the task.(You’ll need to make a name, and I suggest use a file you won’t need to save. Place the macro in that file – You’ll be asked for the location.) Next, use the keys and/or mouse to accomplish the task. Finally, keyboard shortcut Alt-F8 to see a list of (your 1) macro. Select it and click Edit. You will be looking at VBA code.
Compared to old style Macros, there’s lots more you can do to automate spreadsheets. It may take a bit to move up the learning curve (keep checking with the Lounge!), but soon you’ll shake the Macro dust off your shoes.
Errol
-
-
WSTal
AskWoody Lounger
-
-
WSunkamunka
AskWoody Lounger -
WSDougKlippert
AskWoody Lounger -
WSTal
AskWoody Lounger -
WSTal
AskWoody Lounger -
WSJohnBF
AskWoody Lounger -
WSTal
AskWoody Lounger -
WSJohnBF
AskWoody LoungerJanuary 22, 2004 at 10:50 pm #772615Well, that’s a menu sequence to my way of thinking. For a list of keyboard shortcuts for Excel, see Colin’s Star Post 68646.
-
WSJohnBF
AskWoody LoungerJanuary 22, 2004 at 10:50 pm #772616Well, that’s a menu sequence to my way of thinking. For a list of keyboard shortcuts for Excel, see Colin’s Star Post 68646.
-
-
WSTal
AskWoody Lounger
-
-
WSJohnBF
AskWoody Lounger
-
-
-
WSDougKlippert
AskWoody Lounger -
WSduthiet
AskWoody LoungerJanuary 26, 2004 at 9:12 pm #774531Tal:
Attached to this response is a workbook containing 2 Macros for your use.
The first Macro OldTabs will create a new Worksheet called “Tab Control”.
In Column B it will list the current names of each TAB in a workbook
In Column C the Macro will put the same names as in Column B
The user will then use Column C to type in the new desired TAB names. It is very important that Column C has a TAB name
for each worksheet in the workbook or the Macro will not function properly. If you don’t want to change a TAB leave the entry that is already in Column C.
Then run the second Macro NewTabs. This Macro will replace the TAB names with your entries in Column C and Delete Tab Control.Since you are new to Macro’s I suggest the following to use the Macros.
1. Open the attached workbook and save it on your local drive.
2. When needed, open the attached workbook either open the workbook with the tab names you want to change or make it active.
3. Make sure the workbook with the tab names is the Active workbook
4. Then use the shortcut keys ALT + F8 or on the excel menu bar select Tools, Macro, Macro
5. Highligh the Macro you want and hit the Run button.In the long run, you should move the Macros to your personal.xls worksheet and then put custom buttons on your toolbar, attach the Macros to the buttons.
Lastly, below I have included the Macro Code so it can be viewed by the people who view this post.
Regards,
TD
Sub OldTabs()
‘
‘ MyTabs Macro
‘ Macro recorded 1/23/2004
‘
‘Macro Will Create a new worksheet and list all Tab names
‘ Dim MyTabs As Worksheet
Dim MyValue As Integer
Dim WC As Integer
Dim Placeholder As String
Dim r As Integer
‘Procedure MyValue = 10
WC = Worksheets.Count
Worksheets.Item(WC).Activate
Worksheets.Add After:=Worksheets.Item(WC)
ActiveSheet.Name = “Tab Control”
Cells(7, 3).Value = “New Names”
For r = 1 To WC
Worksheets.Item®.Activate
Placeholder = ActiveSheet.Name
Worksheets(“Tab Control”).Activate
Cells(MyValue + r, 2).Value = Placeholder
Cells(MyValue + r, 3).Value = Placeholder
Next r
End SubSub NewTabs()
‘
‘NewTabs Macro
‘Macro recorded 1/26/2004 by duthiet
‘
‘Maco will use list created in Tab Control [Column C]
‘that is then modified by User to rename the Tabs. MyValue = 10
WC = Worksheets.Count
For r = 1 To WC – 1
Worksheets(“Tab Control”).Activate
NewName = Cells(MyValue + r, 3).Value
Worksheets.Item®.Name = NewName
Next r
Application.DisplayAlerts = False
Worksheets(“Tab Control”).Delete
Application.DisplayAlerts = True
End Sub
Viewing 4 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
How well does your browser block trackers?
by
n0ads
1 hour, 48 minutes ago -
You can’t handle me
by
Susan Bradley
3 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
22 minutes ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
9 hours, 22 minutes ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
9 hours, 33 minutes ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
9 hours, 46 minutes ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
9 hours, 51 minutes ago -
Lumma malware takedown
by
EyesOnWindows
17 hours, 5 minutes ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
18 hours, 39 minutes ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
18 hours, 33 minutes ago -
Meet Gemini in Chrome
by
Alex5723
22 hours, 38 minutes ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
22 hours, 47 minutes ago -
Trump signs Take It Down Act
by
Alex5723
1 day, 6 hours ago -
Do you have a maintenance window?
by
Susan Bradley
17 hours, 55 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
8 hours, 57 minutes ago -
Cox Communications and Charter Communications to merge
by
not so anon
1 day, 10 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
1 day, 15 hours ago -
hibernate activation
by
e_belmont
1 day, 19 hours ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
1 day, 22 hours ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
2 days, 1 hour ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
2 days, 1 hour ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
21 hours, 58 minutes ago -
Out of band for Windows 10
by
Susan Bradley
2 days, 6 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
2 days, 13 hours ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
2 days, 21 hours ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
16 hours, 58 minutes ago -
Auto Time Zone Adjustment
by
wadeer
3 days, 1 hour ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
2 days, 23 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
4 hours, 22 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
1 hour, 28 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.