Excel 4.0 Macro Functions Reference
Excel 4.0 Macro Functions Reference
A COMPREHENSIVE LIST OF MICROSOFT EXCEL 4.0 MACRO FUNCTIONS
Philip Treacy
CO-FOUNDER MY ONLINE TRAINING HUB 1
CONTENTS
Introduction ............................................................................................................................................................................................... 22 A1.R1C1 .................................................................................................................................................................................................... 23 ABSREF ...................................................................................................................................................................................................... 23 ACTIVATE ................................................................................................................................................................................................. 24 ACTIVATE.NEXT, ACTIVATE.PREV........................................................................................................................................... 25 ACTIVE.CELL .......................................................................................................................................................................................... 26 ACTIVE.CELL.FONT ............................................................................................................................................................................ 27 ADD.ARROW........................................................................................................................................................................................... 27 ADD.BAR ................................................................................................................................................................................................... 28 ADD.CHART.AUTOFORMAT .......................................................................................................................................................... 28 MAND.................................................................................................................................................................................... 29 ADDIN.MANAGER................................................................................................................................................................................ 33 ADD.LIST.ITEM..................................................................................................................................................................................... 34 ADD.MENU ............................................................................................................................................................................................... 34 ADD.OVERLAY ....................................................................................................................................................................................... 36 ADD.TOOL ................................................................................................................................................................................................ 36 ADD.TOOLBAR ...................................................................................................................................................................................... 39 ALERT .......................................................................................................................................................................................................... 40 ALIGNMENT............................................................................................................................................................................................. 42 ANOVA1 ..................................................................................................................................................................................................... 44 ANOVA2 ..................................................................................................................................................................................................... 45 ANOVA3 ..................................................................................................................................................................................................... 46 APP.ACTIVATE....................................................................................................................................................................................... 46 APP.ACTIVATE.MICROSOFT ......................................................................................................................................................... 48 APPLY.NAMES ........................................................................................................................................................................................ 48 APPLY.STYLE .......................................................................................................................................................................................... 50 APP.MAXIMIZE ...................................................................................................................................................................................... 50 APP.MINIMIZE ....................................................................................................................................................................................... 50 APP.MOVE................................................................................................................................................................................................. 51 APP.RESTORE ........................................................................................................................................................................................ 52 APP.SIZE ................................................................................................................................................................................................... 52 APP.TITLE ................................................................................................................................................................................................. 53 ARGUMENT .............................................................................................................................................................................................. 53
2
ARRANGE.ALL........................................................................................................................................................................................ 55 ASSIGN.TO.OBJECT .......................................................................................................................................................................... 57 ASSIGN.TO.TOOL................................................................................................................................................................................ 57 ATTACH.TEXT ........................................................................................................................................................................................ 58 ATTACH.TOOLBARS........................................................................................................................................................................... 59 AUTO.OUTLINE ..................................................................................................................................................................................... 59 AXES ............................................................................................................................................................................................................ 60 BEEP............................................................................................................................................................................................................. 60 BORDER..................................................................................................................................................................................................... 61 BREAK ......................................................................................................................................................................................................... 62 BRING.TO.FRONT ............................................................................................................................................................................... 62 CALCULATE.DOCUMENT................................................................................................................................................................. 63 CALCULATE.NOW ................................................................................................................................................................................ 63 CALCULATION ....................................................................................................................................................................................... 63 CALLER ....................................................................................................................................................................................................... 65 CANCEL.COPY........................................................................................................................................................................................ 67 CANCEL.KEY ........................................................................................................................................................................................... 67 CELL.PROTECTION ............................................................................................................................................................................. 68 CHANGE.LINK........................................................................................................................................................................................ 69 CHART.ADD.DATA .............................................................................................................................................................................. 69 CHART.TREND ....................................................................................................................................................................................... 70 CHART.WIZARD ................................................................................................................................................................................... 72 CHECKBOX.PROPERTIES ............................................................................................................................................................... 74 MAND .............................................................................................................................................................................. 75 CLEAR ......................................................................................................................................................................................................... 76 CLEAR.OUTLINE ................................................................................................................................................................................... 78 CLEAR.ROUTING.SLIP...................................................................................................................................................................... 78 CLOSE ......................................................................................................................................................................................................... 78 CLOSE.ALL ............................................................................................................................................................................................... 79 COLOR.PALETTE .................................................................................................................................................................................. 80 COLUMN.WIDTH .................................................................................................................................................................................. 80 COMBINATION ...................................................................................................................................................................................... 81 CONSOLIDATE ...................................................................................................................................................................................... 82 CONSTRAIN.NUMERIC..................................................................................................................................................................... 84
3
COPY ............................................................................................................................................................................................................ 84 COPY.CHART .......................................................................................................................................................................................... 85 COPY.PICTURE ...................................................................................................................................................................................... 85 COPY.TOOL.............................................................................................................................................................................................. 87 CREATE.NAMES .................................................................................................................................................................................... 87 CREATE.OBJECT................................................................................................................................................................................... 88 CREATE.PUBLISHER .......................................................................................................................................................................... 92 CUSTOMIZE.TOOLBAR .................................................................................................................................................................... 94 CUSTOM.REPEAT................................................................................................................................................................................. 95 CUSTOM.UNDO..................................................................................................................................................................................... 96 CUT ............................................................................................................................................................................................................... 97 DATA.DELETE ........................................................................................................................................................................................ 97 DATA.FIND............................................................................................................................................................................................... 98 DATA.FIND.NEXT, DATA.FIND.PREV ..................................................................................................................................... 98 DATA.FORM............................................................................................................................................................................................. 98 DATA.LABEL............................................................................................................................................................................................ 99 DATA.SERIES......................................................................................................................................................................................... 99 DEFINE.NAME ......................................................................................................................................................................................101 DEFINE.STYLE .....................................................................................................................................................................................103 DEFINE.STYLE Syntax 1...............................................................................................................................................................103 DEFINE.STYLE Syntaxes 2 - 7 .................................................................................................................................................104 DELETE.ARROW .................................................................................................................................................................................106 DELETE.BAR.......................................................................................................................................................................................... 106 DELETE.CHART.AUTOFORMAT .................................................................................................................................................106 MAND ..........................................................................................................................................................................107 DELETE.FORMAT ................................................................................................................................................................................ 108 DELETE.MENU .....................................................................................................................................................................................108 DELETE.NAME...................................................................................................................................................................................... 109 DELETE.OVERLAY.............................................................................................................................................................................. 109 DELETE.STYLE ..................................................................................................................................................................................... 109 DELETE.TOOL ......................................................................................................................................................................................110 DELETE.TOOLBAR ............................................................................................................................................................................. 110 DEMOTE ................................................................................................................................................................................................... 111 DEREF .......................................................................................................................................................................................................111
4
DESCR ......................................................................................................................................................................................................112 DIALOG.BOX ........................................................................................................................................................................................113 DIRECTORY ...........................................................................................................................................................................................116 DISABLE.INPUT ..................................................................................................................................................................................117 DISPLAY................................................................................................................................................................................................... 117 DISPLAY Syntax 1 ............................................................................................................................................................................117 DISPLAY Syntax 2 ............................................................................................................................................................................118 DOCUMENTS ........................................................................................................................................................................................120 DUPLICATE ............................................................................................................................................................................................121 ECHO .........................................................................................................................................................................................................121 EDITBOX.PROPERTIES ..................................................................................................................................................................122 EDIT.COLOR .........................................................................................................................................................................................122 EDIT.DELETE ........................................................................................................................................................................................ 123 EDITION.OPTIONS ...........................................................................................................................................................................124 EDIT.OBJECT ........................................................................................................................................................................................ 127 EDIT.REPEAT ........................................................................................................................................................................................ 128 EDIT.SERIES ........................................................................................................................................................................................128 EDIT.TOOL ............................................................................................................................................................................................. 129 ELSE ...........................................................................................................................................................................................................130 ELSE.IF ..................................................................................................................................................................................................... 130 EMBED ......................................................................................................................................................................................................131 MAND .......................................................................................................................................................................... 131 ENABLE.OBJECT ................................................................................................................................................................................. 132 ENABLE.TIPWIZARD .......................................................................................................................................................................133 ENABLE.TOOL ......................................................................................................................................................................................133 END.IF ......................................................................................................................................................................................................133 ENTER.DATA ......................................................................................................................................................................................... 134 ERROR ......................................................................................................................................................................................................135 ERRORBAR.X, ERRORBAR.Y ......................................................................................................................................................136 EVALUATE ..............................................................................................................................................................................................139 EXEC ..........................................................................................................................................................................................................139 EXECUTE .................................................................................................................................................................................................141 EXPON....................................................................................................................................................................................................... 142 EXTEND.POLYGON ...........................................................................................................................................................................143
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- using sas dde sas macro and excel vba macros to create
- macros for financial applications
- primer in excel vba
- excel vba notes for professionals
- 040 30 a macro for importing multiple excel worksheets
- excel 4 0 macro functions reference
- intro and proper configuration depauw university
- instructions for configuring and opening excel workbooks
- excel advanced course materials
- excel chapter 12 templates styles and macros
Related searches
- minecraft education edition 1.4.0 download
- 4.0 ford engine diagram
- 4.0 ford engine exploded view
- 4 0 biosyn
- ford explorer 4.0 engine diagram
- 4.0 ford engines for sale
- minecraft education edition 1 4 0 download
- minecraft 0 4 0 download
- 4 0 jaguar engine for sale
- 4 0 ford engine diagram
- 4 0 ford engine exploded view
- ford explorer 4 0 engine diagram