Next and Previous Button and De-Activate at Last Sheet

Solved/Closed
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 17, 2015 at 09:56 AM
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 18, 2015 at 10:09 AM
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.
0
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 1
Nov 18, 2015 at 10:09 AM
Thanks
Great Job Excellent Performance
also shows good idea for Quick Access Menu
0