How can I Hide Sheet 2 from a Value in sheet 1

How familiar are you with VBA? You would need an event handler to capture the value entered, then show/hide the appropriate sheets. Something like:

Please Login or Register  to view this content.

This uses the Worksheet_Change event handler - this should be in the worksheet module.

Hope this helps!

Originally Posted by swieduwi

Some what new at VB,

I will annotate my code a little better:

Please Login or Register  to view this content.

To put the code in the worksheet module, hit Alt-F11 to get into the VB Editor. On the left-hand side, right-click on the worksheet you are checking, and click "View Code". Cut and paste the above code sample into the module. Change x and y in the a=ActiveSheet.Cells(x,y).Value statement to reflect the actual cell you are checking against. Also change the Sheet names to reflect the sheets that you want to show (Visible = true) and hide (Visible = false).

I hope this clarifies everything.

I tried it and could not get it to work.....

I then tried this and it works but it's ugly and not very smooth

Please Login or Register  to view this content.

Why is it not smooth? Looks OK to me. You can add Appliction.Screenupdating = False to the beginning to make the screen changes invisible until their done.

If it works, use it.. BTW, I left something out of my original code.

My (revised) code equivalent to yours:

Please Login or Register  to view this content.

If you noticed, your case "x" and case "s" were exactly the same...

HTH

Yea, Yours just Looks so much more Professional

Mine looks amature ( oh wait I am )

If you noticed, your case "x" and case "s" were exactly the same...

Yea, there will be another diagram for X just not finished with it yet.