Can't think exactly how to do it but you could modify the code from this post (#5) to suit your purposes.
should work
post 5 is the one you want.
this opens up a hidden sheet given a specific date, you could modift it to open on a row in a sheet.
hth