Thanks: 0
Likes: 0
What I have is a mutli page workbook and I would like to know how to use or program the command buttons to jump to the next page of the work sheet or to anothe rpage in the work book.
To select the Next page use this code:
ActiveSheet.Next.Select
or the previous one
ActiveSheet.Previous.Select
To go to another page, there's an easier way, right click on the arrows at the left of the Worksheet Tabs, you'll see a list of all your sheets and you can click one of them to go instantly to it.
Reply With Quote
Like this thread? Share it with others