Selecting Hiden Sheets

[shiftyspina]

Hi All

I have this code that is in my contents page

Please Login or Register  to view this content.

There are 48 sheets in my workbook, and i want to hide a large amount

When i hide sheets, if i click on say page 21 but its hiden it takes me to the next unhiden sheet, in this example page 26.

Is there a way to stop this from happening without having the sheet unhidden?

Dan

[ragulduy]

What do you want to happen instead when you click on page 21 and it is hidden?

[shiftyspina]

I want to be able to go into that sheet, the likeness is that i wont need to (hence hiding the sheet) but rather than having to select unhide, then scroll through a list of sheets to find it, i would like the code to be able to do that in the contents sheet

[ragulduy]

check if it is hidden before you try to activate it?

Please Login or Register  to view this content.

[shiftyspina]

Hi

Yeah the sheet is hidden and by using your code above

Please Login or Register  to view this content.

It just gives me the error message

i also tried

Please Login or Register  to view this content.

but that told me the (21) was worng, obviously no "'s

[shiftyspina]

then tried with "'s and still no joy

[ragulduy]

Sorry, mistake on my part. You want to use .visible not .hidden, so:

Please Login or Register  to view this content.

[Norie]

If the sheet is hidden how are you clicking it?

[shiftyspina]

Thats great works fine, except i had to swap the code round so it said

Please Login or Register  to view this content.

This then unhide the sheet if it was hidden

Thanks for your help yudlugar

Norie, i have a contents page as my first tab in excel and because i want to be able to have some sheets hidden, rather than having to select unhide and scroll through the list, i wanted a code to unhide it, the contents page has command buttons which activate the sheet you require when clicking it