Command Buttons

[eddieque]

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.

[Juan Pablo González]

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.