Speed Up Macro in VBA

Hi,
I have used alot of If statement to hide and unhide rows depending on the option selected from several drop down lists. To do this I used "Private Sub Worksheet_Change(ByVal Target As Range)". It works fine but since everytime i enter a value all these if statements run, the program becomes slow.

Is there a more effective and efficient way to do this.

Any help is much appriciated
Thanks

is there specific cells you are trying to trap changes in to trigger the event or is it really any cell update that you are looking for?

would a "calculate" button attached to a macro do what you are trying to do

Hi,

No, there are no calculations. Its just a form so I am hiding selected areas depending on which one they select from the list.

Thanks