sheet switch!

[bronwyn]

hi again, im also trying to accomplish switching from one sheet to another using a simple command button, any code available to achieve this?...thanks in advance

 

[tony0682]

Are you trying to incorporate this into a macro? If not, page switching can be accomplished by hitting Control + Page up or Control Page Down

 

[bronwyn]

yeh im trying to accomplish this using vba! ;-0

 

[tony0682]

You can easily record a macro and look at the code to see how its done.

ActiveSheet.Next.Select
Goes to the next sheet in order

ActiveSheet.Previous.Select
Goes to the previous sheet in order

Sheets("Sheet2").Select
Goes to Sheet2 in Workbook

 

[bronwyn]

works perfect, thanks!