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 :)