Automatically Hide Row based on Cell in another sheet

It works. But I need this for rows of sheet a and colun of sheet B. for example value of Sheet 2s came form rows A1 to z1 . In that case what will be the VBA code

Thanks in Advancebe