Previous Topic Next Topic

Next and Previous Button and De-Activate at Last Sheet

Solved/Closed
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 17, 2015 at 09:56 AM
smuneeb Posts 67 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
Related:

1 response

Answer 1 / 1
RayH
Nov 17, 2015 at 04:37 PM 
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.
smuneeb Posts 67 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