Microsoft Office Tutorials and References
In Depth Information
VBA: Written Behind the Scenes
Now, as mentioned, I’m not going to teach you the VBA language here; rather, we’re just
going to take a look at it and explore some easy ways to tweak it in order to edit a
macro.
VBA: Written Behind the Scenes
It’s far from obvious, but whenever you record a macro of the sort demonstrated here,
its commands are also transcribed simultaneously in the VBA language, on a separate
worksheet that’s usually hidden. But once you reveal that worksheet, you’ll see the Logo
and Logo2 macros as they appear in VBA translation, so to speak, giving you the chance
to actually rewrite the script and affect the ways in which the macros play out.
Exposing the VBA Worksheet
Revealing that hidden VBA worksheet is easy. Just click View Macros (down arrow)
View Macros, and in the Macro dialog click Logo, and then click Edit (see Figure 11–16).
Figure 11–16. Clicking Edit will take you to the worksheet’s Visual Basic window.
When you do, you’ll see the macro as shown in Figure 11–17 (the window here has been
maximized in the figure).
 
Search JabSto ::




Custom Search