View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tony7659 Tony7659 is offline
external usenet poster
 
Posts: 32
Default Object Selection

I have found that for some reason one of the tabs on my spreadsheet contains
thousands of blank "Text Boxes". The text boxes do not have borders so they
are invisible thus causing a slowdown in that particular area of the
spreadsheet tab. Is there a way to select them all and delete them in one
shot? or, Can I create a macro that goes let's say from the first text box to
about 55,000 and delete them one at a time? Please advise. Thank you. Tony.