View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ScottO
 
Posts: n/a
Default Embedded Text Box

Hit F5, click on Special, select Objects, click OK, hit delete.
Beware - ALL objects will be deleted, so if you've got some that you
want to keep, hold down Ctrl and deselect the loved ones.
Rgds,
ScottO

"EK" wrote in message
...
| For unknown reason, I had more than 7000 blank text boxes embedded
in my
| spreadsheet. Seemed like one on top of the other. This blew up my
file to
| about 1.44Mb and considerably slowing down the performance. Is
there a way to
| delete those text boxes really quick?
|
| Thanks in advance.
|
| Evan