key stroke to switch tabs

[leecavturbo]

any way for key stroke to tab through several sheets?

 

[leecavturbo]

It's worksheets I want to key stroke to. I.e the 3 worksheets the default workbook setting creates.
So if I'm currently viewing sheet1 I want a key stroke to switch to the next worksheet (sheet2)

 

[leecavturbo]

just recorded what i want to do but the problem is thats to sheet"2" not "next"! ????

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 18/06/2014 by steph
'

'
Sheets("Sheet2").Select
End Sub

 

[leecavturbo]

bit of playing but finally got it. not a keystroke but good enough

Sub SheetTab()
'
' SheetTab Macro
' Macro recorded 18/06/2014 by lee
'
' Keyboard Shortcut: Ctrl+z
'
On Error Resume Next
Sheets(ActiveSheet.Index + 1).Activate
If Err.Number <> 0 Then Sheets(1).Activate
End Sub

 

[Fazza]

It is a mystery why (if?) the normal keystrokes were not OK for you.

This is only repeating what others have posted, but just in case it helps...

If you're on sheet 1 and want to get to sheet 2 that is CTRL-PAGEDOWN

Repeat to go one more worksheet down. For the opposite direction, CTRL-PAGEUP

No macro required. HTH. Regards

 

[leecavturbo]

Is it because I'm using 2003?
Ctrl+page down, scrolls me down rows in big steps

 

[Fazza]

No, it isn't because of Excel 2003. The shortcut has been around since 'forever'.

I can't recall why you're seeing non-standard (?) behaviour. Though I'm sure I've seen it in the past...

Suggest you look under ALT-T-O (options). I think there must be a setting to toggle it. I think it not a keyboard thing, but a setting. Like navigation keys or compatibility with Lotus. Or something..

I'll google too. Cheers

 

[RoryA]

Is there any worksheet protection in place? That can interfere with the shortcut depending on the settings.

 

[leecavturbo]

No protection. I've just tried this on another pc win7 excel 2007. Same action just scroll many rows

 

[Fazza]

Google didn't help me much.

Can you check the CTRL key is working OK? (I know this seems unlikely when you've checked & found the same behaviour on a second computer.)

 

[leecavturbo]

Google didn't help me much.

Can you check the CTRL key is working OK? (I know this seems unlikely when you've checked & found the same behaviour on a second computer.)

Yep it works. And as above same action on another pc