Next and Previous Button and De-Activate at Last Sheet [Solved/Closed]

Report
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Hello,


I would like to request to create a button on Sheet that will click which goes to next sheet and
this button also de-activate when it goes to last sheet.
and it could worked same as for Previous Sheet
Thanks

1 reply

Sub PrevSheet()
If ActiveSheet.Index = 1 Then Exit Sub
Worksheets(ActiveSheet.Index - 1).Select
End Sub

Sub NextSheet()
If ActiveSheet.Index = Worksheets.Count Then Exit Sub
Worksheets(ActiveSheet.Index + 1).Select
End Sub


The button to call these macros would either need to be in each sheet or added to the Quick Access menu.
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
1
Thanks
Great Job Excellent Performance
also shows good idea for Quick Access Menu

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!