userforms and worksheet help

[paradise]

How do i write a code which allows sheet1 to be shown
first upon opening a workbook?


I have a series of userforms ranging from 1 to 10 which activates when
opening sheet1.
at Userform10, i have command button which allows user to
click and close all the forms and activate sheet 2 instead. how do i
write the code?


Thanks in advance

 

[Bob Flanagan]

To display sheet1 on opening the workbook:

Sub Autpen()
Sheets("sheet1").select
End Sub

To go to sheet2, use

Sheets("sheet2").select

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel