Auto Hide Rows

[Faren]

Hey guys,

I am trying to work out how I can get rows within my worksheet to automatically hide when a cell contains the value "Restricted Access". Ive been able to get the rows to hide using a ctrl Key however i want this to happen automatically when the value is chosen from a drop down box

[ARGK]

Hi
Can you advise which cell will determin that rows need hiding and which rows you wish to hide.
This can be done with a small macro but I need the above info first.
Tony