Next, before (sheets)

[Guanjin Peter]

how do you scroll through next sheet and the sheet before? I couldn't record it using macro....

was going to assign it to a macro and make a custom toolbar.

 

[DonkeyOte]

ActiveSheet.Next.Select

or

ActiveSheet.Previous.Select

the keyboard shortcut is CTRL + PAGEUP/PAGEDOWN if you want to record.

 

[Stormseed]

Activesheet.Next.Select

ActiveSheet.Previous.Select

 

[Guanjin Peter]

w0w, thanks!

it goes on error once it goes beyond the number of sheets. So how do I exit on error?

 

[DonkeyOte]

is it in a loop of somesort ?

if not just use

On Error Resume Next

 

[Guanjin Peter]

couldn't work

Sub Macro4()
  ActiveSheet.Next.Select
  On Error Resume Next
End Sub
Sub Macro5()
    ActiveSheet.Previous.Select
    On Error Resume Next
End Sub

 

[DonkeyOte]

place handler prior to executing, ie

On Error Resume Next
ActiveSheet.next.select

 

[Guanjin Peter]

works wonders. thanks