hiding pivot tables
 

I have two pivot tables on a tab - I want to hide the pivots based off the
whether the user clicks row one (cell a1) 1st pivot table or row two (cell
a2) 2nd pivot table.

if the user selects 2nd pivot table - rows 2 - 43 would "hide" if the user
selects 1st pivot table - rows 43+ would "hide".

Any suggestions on how I accomplish this via VBA