Join Dennis Taylor for an in-depth discussion in this video Understanding security, part of Excel 2010: Macros in Depth.
- View Offline
- Exercise Files
Even before grasping the full meaning of what a macro is, you need to know about…the security issues associated with macro usage.…Currently on the screen I'm using a file that doesn't have any micros in it.…It's called Profits.…You might notice its file extension, and depending upon your display…settings, you might not be seeing a file extension yourself. But the standard…file extension in Excel files in 2010 is .xlsx.…I'm about open another file.…This file is called Large Macro Example.…
You will notice its file extension, xlsm. That means it has macro in it.…I'm going to open this simply by double-clicking, and here is a prompt:…"Microsoft office has identified a potential security concern," and the warning sounds…rather dire. But I think lot of you know, and you been warned by your IT…departments in many cases, that macros can be a repository for viruses.…So the default notice in Excel will appear like this when you open a file…that has macros in it.…
We certainly like to run macros, so we'll enable the macros.…
- Understanding what a macro does
- Recording and adding functionality to a macro
- Running macros
- Creating non-recordable VBA code
- Testing a macro in Step mode
- Joining two macros
- Using loop structures
- Streamlining macros
- Creating a Personal Macro Workbook
Skill Level Intermediate
1. Getting Started
2. Running a Macro (Execute, Play Back, Etc.)
3. Using Visual Basic for Applications (VBA)
Viewing the VBA components6m 50s
4. Recording a Macro in Stages
Recording a simple macro5m 52s
5. Creating Non-Recordable VBA Code
6. Macro Project: Converting a Mailing List into a Database List
7. The Personal Macro Workbook
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.