title: Slow running code due to a lot of objects hiding / unhiding
body: <p>I have a spreadsheet of about 20,000 rows.  This spreadsheet is a hierarchy that displays part lists for pieces of equipment.  I have created code that creates buttons (actually the shape rectangle) that allow the user to expand / contract these groups through hiding / unhiding rows.</p>
  
  <p>I believe the code is running slow because there are several thousand buttons on the spreadsheet that I believe are refreshing each time rows are hidden.  When I click the button the code runs, the correct rows hide / unhide, then all the buttons dissapear for a few seconds then reapear. The disapearing occurs after the rows hide or unhide so the code has already finnished running.</p>
  
  <p>Is there any way to stop Excel from refreshing every button? Is there a different issue?</p>