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.
0
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
0