thekneeguy
10-06-2005, 06:32 AM
Hello
I have two worksheets in an excel progam (2002). What I would like is this but I am not sure how to do all of this at once.
I would like the first sheet ""sheet 1" to be visibe on opening the program. This is a sort of splash page which provides updates to products, discontinued items, etc. From this page, the user may opt to view a tutorial video which explains the program. (This part works fine.) Or the user may opt to bypass the turorial and click a second command button which would activate a user sign on (a user form with an input box for a password which customizes some of the information based on the entry and then the second "inventory" sheet becomes visible. The user form with the password is working as well. I just really know how to
1) make sheet 1 be the default for onopen and
2) have the command button on sheet 1 execute the signon form and then show the inventory sheet.
I hope someone can help with this. I think maybe I am confusin some of the steps.
Thank you
I have two worksheets in an excel progam (2002). What I would like is this but I am not sure how to do all of this at once.
I would like the first sheet ""sheet 1" to be visibe on opening the program. This is a sort of splash page which provides updates to products, discontinued items, etc. From this page, the user may opt to view a tutorial video which explains the program. (This part works fine.) Or the user may opt to bypass the turorial and click a second command button which would activate a user sign on (a user form with an input box for a password which customizes some of the information based on the entry and then the second "inventory" sheet becomes visible. The user form with the password is working as well. I just really know how to
1) make sheet 1 be the default for onopen and
2) have the command button on sheet 1 execute the signon form and then show the inventory sheet.
I hope someone can help with this. I think maybe I am confusin some of the steps.
Thank you