Use checkbox to show/hide sheets?

Hey

Im having a small problem that im trying to solve in some way. I only have some knownledge in basic macros and not in VBA, and since i cant figure out a way to solve my problem.

Is it possible to do this.

I have a workbook (i attach a testfile). Right now i have 4 sheets in it. The "Main Sheet" is called "Pre"

Here i have 3 checkboxes.

I also have 3 "hidden" sheets called "sheet1", "sheet2" and "sheet3".

What im trying to do is when i "mark" the checkbox called "sheet1" then i want the hidden "sheet1" to show up. And same goes with all the sheets.

So basicly when i click "sheet1" checkbox that sheet will get unhidden.

It's a little easier to use the Control Box Check boxes for this instead of the forms. after adding the boxes and changing the captions, I put this code in:

Please Login or Register  to view this content.

As you can see, it lets you hide/unhide sheets based on what you've put in the check box captions, so you don't have to keep editing the code if you change the sheet names, just change the captions and it will keep working.

If you stick with Form Controls then repeat this for each checkbox

Please Login or Register  to view this content.

I would use ActiveX controls as Jerry shows

Thanks a ton both of you for the help, exactly what i need.

Another question in the same matter, is it possible to open 2 or more sheets with the same checkbox?

Just add as many as you need to open

Please Login or Register  to view this content.

With Jerrys' code you will probably need to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

If you want to avoid complications

Hope this helps.

A fun option to not have to use IF/THEN :

Please Login or Register  to view this content.