hiding sheets and sheet visibility

[cocopops2001]

is there anyway i can have pages that are 'hidden' but still allows the user to select them i am currently using a button? the

sheets(x).select

does not work when the sheets are hidden. not xlveryhidden just xlhidden.

i have also tried

 sheets(x).activate

to no avail. it goes to the next sheet in the line, ie when i want sheet 5 it goes to sheet 6.

any ideas?

 

[Alpacino]

Sorry insteadof activate should be Select.