Microsoft Excel (Text Box)

[mauromalacara]

I have an excel spread sheet file with a lot of text box blank hide on every where of spread sheet, I am finding one by one and removing, Is there any way that let me erase all "text box blank" of once....

 

[SkipVought]

Hi,

This will delete ALL OLE Objects on your sheet, ie controls, pictures, etc.

copy this code to a vba module (alt+F11 opend the vb editor) and Tools/Macro/Macros - Run DeleteShapes...

sub DeleteShapes()
dim sh as shape
for each sh in activesheet.shapes
  sh.delete
next
end sub

Save your workbook BEFORE running this macro.

Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[BenRowe]

In Edit, Go To, Special, click on Objects and then OK, all text boxes will be selected.

 

[mauromalacara]

thanks so much both of you,,,,,,,,,,that really help me