Home Button

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

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

Thanks & Regards

1 response

Sub PrevSheet()
End Sub

Sub NextSheet()
End Sub

Sub HomeSheet()
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.