Excel 2007：Introduction to Macros.pdf

《Excel 2007：Introduction to Macros.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Excel2007:IntroductiontoMacrosInstructionalServicesatKULibrariesADivisionofInformationServiceswww.lib.ku.edu/instructionThishandoutcoversthebasicsofcreatingandeditingAbstract:MacrosinExcel2007.NavigatingtheVisualBasicEditorandcreatingbasiceditsintheVisualBasicEditorwillalsobecovered.ContentsRelate

2、dTrainingAvailablefromInstructionalServices................................................................2Introduction.....................................................................................................................................2MacroSecurity...............................

3、.................................................................................................2EnableAllMacros...........................................................................................................................4RecordingMacros..............................................

4、.............................................................................6PlayingaMacro..............................................................................................................................9AssigningaKeystroketoaMacro.....................................................

5、...........................................10RecordingaRelativeReferenceMacro........................................................................................12RunningaRelativeReferenceMacro...........................................................................................13Copyinga

6、MacrofromaWorkbookorTemplate........................................................................14VisualBasicandMacros..............................................................................................................15OpeningtheVisualBasicEditor.....................................

7、..............................................................15©2009TheUniversityofKansas.AllrightsreservedInstructionalServicesExcel2007:IntroductiontoMacrosUnderstandingtheMacroCode............................