Hide/Unhide Rows Based On Drop Down Selection

Hi,

I've been struggling with the following:
-I have a drop down selection on sheet 1.
-Based upon that, a corresponding cell on sheet 2 is changed to "Passed" or "Failed".
-The VBA code I currently have is set up to hide rows 43-46 if that value is "Failed" and have it unhide 45-48 if it is "Passed.
-Everything works fine, accept for the fact that anytime I change ANY cell, the sheet recalculates.
-Based upon the fair amount of entry that will take place in this workbook, this could considerably slow down the efficiency of the sheet.
-I'm using the "Private Sub Worksheet_Calculate()" function. Should I not be? What am I doing wrong?

Here's my code:

Please Login or Register  to view this content.

Hi Brian,

Welcome to the Forum We wrap our code in code tags, you only need to highlight the code and click on the # (you can just edit post #1).

Can you upload a sample spreadsheet? Don't post anything confidential etc! Just click on Go Advanced and then the paper clip

Hi Brian,

Thanks for the rep! Try this instead:

Please Login or Register  to view this content.

Hi Brian,

In the sheet:

Please Login or Register  to view this content.

In Module1:

Please Login or Register  to view this content.

I had to fiddle with the sheet protection and, finally that worked for me. Try playing with the protection. Review - Unprotect Sheet


In the sheet code, you'll find a TestCh - Play that by hitting F8 to single step. Among other things, it will reset your events

AQBrian.xlsm

I edited my last post - take another look

Hey Brian,

I didn't mean to use the TestCh regularly - I just meant to use it to test the Event Code - and, as a bonus, to reenable events!

BTW - how do Passed/Failed get into that "U5"?

Since Excel is so particular:

Please Login or Register  to view this content.

*all that I can think of until I find the origin of the "U5" entry