Learn more about this later in this chapter, as well as how to get help for finding commands that can’t be recorded. You can do a great many things when writing VBA that can’t be done by recording macros, such as applying a document theme (or, in the preceding example from Office 2011, automating Find and Replace tasks). In some cases, a macro that can’t be recorded means that you can’t accomplish the task through VBA, but it doesn’t always. For example, if you record a macro while adding items to the Quick Access Toolbar in Office 2010 or using the new Search In box above the Ribbon in Office 2011, your steps won’t be recorded. One thing we all run into at some point, however, is the fact that there are a few commands that can’t be recorded. Experienced VBA users continue to find macro recording useful for learning how to accomplish new tasks in VBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |