VBA code to open next sheet or go back to previous

**ABSTRAKTUS** · 10-14-2010, 06:44 AM

Hi Gurus,

I have a spreadsheet lets say with ten sheets in it. Is there a possibility (of course there is) to have a "Next" and "Back" buttons on each of them. The point is instead of clicking on next or previous tab, I'd like to do that with buttons. Thoughts?

**Richard Buttrey** · 10-14-2010, 06:51 AM

Hi,

Untested but something like

Sub GotoNextSheet
   Sheets(ActiveSheet.Index + 1).Activate

End Sub

and similar for a GotoPreviousSheet but with a - 1
HTH

**ABSTRAKTUS** · 10-14-2010, 07:18 AM

Thanks a ton. Its so easy...

**royUK** · 10-14-2010, 07:21 AM

Alternative

Option Explicit

Sub x()
ActiveSheet.Next.Select
End Sub
Sub y()
ActiveSheet.Previous.Select
End Sub

VBA code to open next sheet or go back to previous

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VBA code to open next sheet or go back to previous

Re: VBA code to open next sheet or go back to previous

Re: VBA code to open next sheet or go back to previous

Re: VBA code to open next sheet or go back to previous

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions