You indicated in your original post that you wanted to use the sheet activate
event.

to make the code execute, you would have to select another sheet, then come
back to the sheet where you want the rows to be hidden (the sheet with the
code). (you did put the code in the sheet module, correct).

If you want it to happen every time there is a calculate, then put the code
in the calculate event for the sheet where you want the rows hidden.

Anyway, as expected, it worked fine for me.

--
Regards,
Tom Ogilvy


" wrote:

Thankyou to both of you for the replies but it doesnt seem to work.
ill explain a little mo

In Cell C6 To C43 I have This:
='Overdue Review'!A4
'
='Overdue Review'!43
Which basicly looks at a different sheet in my workbook, it is either
a yes or a no.

If this cell equals No then i want it to hide,
If this cell equals Yes then i want it to be shown,

And i was wondering could this be done?