[scouse13]

i have 6 checkboxes on a worksheet, what i would like to happen is depending on which checkboxes are checked and then a command button pressed, a particular worksheet will open i.e

checkbox1 and checkbox2 ticked = worksheet2
checkbox3, checkbox4 and checkbox5 = worksheet4
checkbox1 and checkbox3 = worksheet 5

etc
can anyone help with the code

thanks

[Zack Barresse]

Hi there,

Are you able to post your file? Also, please define all combinations and which action will happen. Also, I'm not sure, because of your terminology, what is going to happen. You say you want to open a worksheet, well, you can't do that. You can open a workbook, or you can activate a worksheet, but not open a worksheet. Does that make sense? Also, please make sure you tell us exactly what it is you are trying to do, the end result

[scouse13]

thanks for the reply zack,

hopefully the following will clarify what i need

i have set up a few darts games on the laptop to make it easier to use i would like the first worksheet to have checkboxes defining which game to go to and how many players,
so the first 4 checkboxes will be number of players 1-4
the next 4 checkboxes are the choice of games

what i would like to happen is if say the 2 players(checkbox)is checked and game number 3 is checked then on pressing a command button it will activate that particular worksheet
it needs to be set up for all possible choices i.e 1 player game 1
2 player game 1
1 player game 2 etc
also if 1 of the player checkboxes is checked but none of the game ones are checked or vice versa an error message appears asking the user to check a game box

hopefully this explains it a bit more
thanks
scouse13