Microsoft Office Tutorials and References
In Depth Information
Automating Commands with Macros
After you follow a hypertext link to its destination, the color of its text changes
from the traditional blue to a dark shade of purple (without affecting its
underlining). This color change indicates that the hyperlink has been used. (Note,
however, that graphic hyperlinks do not show any change in color after you
follow them.) Additionally, Excel restores this underlined text to its original
(unfollowed) blue color the next time that you open the workbook file.
If you need to edit a hyperlink attached to a worksheet cell or graphic object,
you must be careful that, when getting Excel into Edit mode so that you can
change the text, you don’t inadvertently follow the link. When dealing with
hypertext in a cell or assigned to a graphic object, you’re best off right-clicking
the cell or image and then clicking the appropriate editing command (Edit
Hyperlink or Remove Hyperlink) on its shortcut menu.
Automating Commands with Macros
Macros automate the Excel worksheet by enabling you to record complex
command sequences. By using macros that perform routine tasks, you not
only speed up the procedure considerably (because Excel can play back your
keystrokes and mouse actions much faster than you can perform them
manually), but you are also assured that each step in the task is carried out the
same way every time you perform the task.
Excel macro recorder records all the commands and keystrokes that you
make in a language called Visual Basic for Applications (VBA), which is a
special version of the BASIC programming language developed and refined by the
good folks at Microsoft for use with all their Office application programs. You
can then later learn how to use Excel’s Visual Basic Editor to display and make
changes to the macro’s VBA code.
Recording new macros
Excel 2013 enables you to add an optional Developer tab to the Ribbon that
contains its own Record Macro command button (among other command
buttons that are very useful when doing more advanced work with macros).
To add the Developer tab to the Excel 2013 Ribbon, follow these two steps:
1. Choose File Options or press Alt+FT to open the Excel Options dialog
box.
2. Click the Customize Ribbon tab, select the Developer check box under
Main Tabs in the Customize the Ribbon list box on the right side of
the dialog box, and then click OK.
Search JabSto ::




Custom Search