由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Windows版 - Re: excell expert, please help!!!
相关主题
Re: office 编程(excel)的菜鸟问题Re: Help: L macro in VC++
Re: [转载] 这里有没有excell高手啊,帮帮忙吧。哪个MACRO软件可以用外部命令调用执行?
excel programmingexcel: automatically executed macro
请教:如何找到或者删除excel中隐藏的表?how write a Win XP batch file
求解:双击excel文件后很久才能打开word VBA question (转载)
excel slowsave a VBA macro in excel using vbscript
Re: Big shrimps, anybody recommend me a Macro virus killer?how to open 32 bit excel file on 64 bit system?
Vista分区[转载] EXCEL问题求教
相关话题的讨论汇总
话题: excell话题: expert话题: shapes话题: choose话题: file
进入Windows版参与讨论
1 (共1页)
s**********i
发帖数: 711
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.
1 (共1页)
进入Windows版参与讨论
相关主题
[转载] EXCEL问题求教求解:双击excel文件后很久才能打开
Re: one question about Excelexcel slow
Re: Excel 一问Re: Big shrimps, anybody recommend me a Macro virus killer?
Re: excel 里怎么让 text 一行绿 一行白的?Vista分区
Re: office 编程(excel)的菜鸟问题Re: Help: L macro in VC++
Re: [转载] 这里有没有excell高手啊,帮帮忙吧。哪个MACRO软件可以用外部命令调用执行?
excel programmingexcel: automatically executed macro
请教:如何找到或者删除excel中隐藏的表?how write a Win XP batch file
相关话题的讨论汇总
话题: excell话题: expert话题: shapes话题: choose话题: file