|
The Macros
are written in Microsoft's Visual Basic for Applications
(VBA) programming language. Here are the steps to Edit a
Macro in VBA.
5.
Try it: Edit the Macro Go to
Developer ->Code. Click on
Macros. Select a
Macro: AddNewRow. Click on
Edit. What Do
You See? The VBA Editor should open in a new window. On the left
side should be a VBAProject. Each sheet, and the tab name, is
listed in the Excel Objects. Keep
going...!
Memo to Self: This is the same
VBA editor that you can use in Microsoft Access, Outlook, PowerPoint
and Word to program Macros.
Exam 77-888: Microsoft Excel Expert
2010
4. Working with Macros and Forms
4.1. Create and manipulate macros.
Developer ->Code->Macros-> Edit
|
|
| |
