Home Button [Solved/Closed]

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

I would like to request for the Macro which always take to "Sheet1" and also deactivated at "Sheet1"

Thanks & Regards

1 reply

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.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!