Home Button
Solved/Closed
smuneeb
Posts
67
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Nov 18, 2015 at 10:12 AM
rayh - Nov 18, 2015 at 11:19 AM
rayh - Nov 18, 2015 at 11:19 AM
Related:
- Home Button
- At button - Guide
- New outlook refresh button - Guide
- Control button not working - Guide
- Insert button on keyboard - Guide
- Ps3 controller reset button - Guide
1 response
Sub PrevSheet()
ActiveSheet.Previous.Select
End Sub
Sub NextSheet()
ActiveSheet.Next.Select
End Sub
Sub HomeSheet()
Worksheets(1).Select
End Sub
I have updated the code on you previous question and added the Home macro.
This code works as long as there aren't any HIDDEN sheets, in which case it returns an error.
The code needs to take into account where the hidden sheets are, i.e. the first, the last or somewhere in the middle, each case needs to be handled.
So while I take a moment an think about how to handle this I have not done the 'deactivate' sheet code.
