Re: excell expert, please help!!!# Windows - 看得见风景的窗口
s*i
1 楼
tools->macro->visual basic editor.
you will see on left there's something
"VBAproject(file)" where file is your
excel file name. right click on it and
choose insert->module
on right a blank page opens.
copy and paste the following to it:
sub choose_all_shapes
activesheet.shapes.selectall
end sub
now back to excel and tools->macro->macros
click on choose_all_shapes and hit run.
now all shapes in the sheet it chosen,
and you can del them all.