Excel中如何使用VBA实现自动隐藏和显示行?

发布网友发布时间：2022-06-01 02:50

共1个回答

热心网友时间：2023-11-16 00:57

首先向这样的哥们表示最崇高的敬意,只有我们不满足于软件的功能,才不断推动了软件的进步,同时也使我们的软件市场无比的繁荣!!! 其次,你已经具备了一个进行二次开发的精神并且你现在已经在做二次开发的工作了,但你的工具不行.工欲善其事,必先利其器.就算excel再好,你的许多需求也得最起码使用excel的vba程序设计部分来完成了. 最后,祝你可以在知识的台阶上百尽杆头,更进一步. 如果你有sql的基本,那最好找本dephi,vb等等之类的书看一下,然后画个漂亮的界面,做个漂亮的报表,就万事ok了. 最后最后一句,你的高度,excel已经满足不了了,该升级了. 参考 http://zhidao.baidu.com/question/48889573.html?si=10 可以的，用VBA。工具---》宏---》VB编辑器。程序不难。篇幅太长，一下讲不清楚。看帮助也能学会的。参考 http://zhidao.baidu.com/question/70938931.html?si=9 http://office.microsoft.com/en-us/training/CR061831141033.aspx http://office.microsoft.com/en-us/training/CR061831141033.aspx 这是英文的介绍音频的 http://www.microsoft.com/china/office/xp/excel/ http://www.microsoft.com/china/office/xp/excel/ 相应的中文要你找的。 Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993 and its bundling as part of Microsoft Office. Contents [hide] 1 History 2 Versions 3 Logos 4 File formats 4.1 Microsoft Excel 2007 Office Open XML formats 5 Criticism 6 See also 7 References 8 External links [edit] History Microsoft originally marketed a spreadsheet program called Multiplan in 1982, which was very popular on CP/M systems, but on MS-DOS systems it lost popularity to Lotus 1-2-3. This promoted development of a new spreadsheet called Excel which started with the intention to, in the words of Doug Klunder, 'do everything 1-2-3 does and do it better' . The first version of Excel was released for the Mac