Using module to retrieve/call multiple sheets

[kageta]

Hi, does anyone know if you can use the codes from module to call/retrieve multiple sheets. I have created a quiz(game) and I wanted to add "level difficulty" in my quiz. For example, Users can choose to select level 1(beginner), level 2(advanced) and so on from the home page(user form) of the quiz.

Is it possible to create command buttons for them(level 1, level 2) and when level 1 is clicked, sheet1 will be retrieved. When level 2 is clicked, sheet2 will be retrieved. All this from the home page(user form). Please help!

 

[alansidman]

Use the Workbooks On Open event to hide all the sheets and have the form open and visible.
For each of the command buttons unhide the particular sheet you wish to display.