Macro for very hidden/unhide excle sheet....

Hello friends...

I am trying to unhide /very hidden excel sheet based of value in Sheet 1 (A1).

For example:
If Sheet 1 (A1) = 1, then Sheet 2 shall be unhide...
If Sheet 1 (A1) = 2, then Sheet 3 shall be unhide...
and
If Sheet 1 (A1) = 0 unhidden sheets shall be very hidden......

Thanks in advance.....

Jay

Try this sample

Dear Millz,

Thank you very much for the macro....

I tried it and found work nicely....
but there is a little problem....
when Sheet 1 (A1) value reduced from 3 to 2, still the Sheet 3 shown... when Sheet 1 (A1) value reduced to 2 to 1, still Sheet 2 and Sheet 3 shown....
I wish that when value in A1 is reduced the corresponding sheet shall be very hidden.

Originally Posted by jaysakle

I wish that when value in A1 is reduced the corresponding sheet shall be very hidden.

Well, that's very different from what you said in the first post.
Change the worksheet code to this:

Please Login or Register  to view this content.

Dear Millz

Thanks....a lot....

1. It works only up to 7 sheets....i need more up to 100 sheets....
2. Value starts in A1 is from 2...means... if 2 is entered in A1 sheet 2 opens.....the value starts from 1...means if 1 is entered in A1 sheet 2 shall be open/show....

Thanks in advance....

Originally Posted by jaysakle

1. It works only up to 7 sheets....i need more up to 100 sheets....

From what I see... it should be working for any amount of sheets.

Originally Posted by jaysakle

2. Value starts in A1 is from 2...means... if 2 is entered in A1 sheet 2 opens.....the value starts from 1...means if 1 is entered in A1 sheet 2 shall be open/show....

Yes I sort of made it count together with the sheet number, since Sheet 1 (where you enter the value in A1) should always be shown. But if you want the second sheet to start as "1", here it is. Attached example is working for 100 worksheets.

Originally Posted by millz

From what I see... it should be working for any amount of sheets.

Yes I sort of made it count together with the sheet number, since Sheet 1 (where you enter the value in A1) should always be shown. But if you want the second sheet to start as "1", here it is. Attached example is working for 100 worksheets.

Thanks....thanks...thanks....work nicely and up to mark....