BUS 150 Study Guide - Midterm Guide: Dialog Box, List Of True Blood Characters, Strikethrough
12 Mar 2014
School
Department
Course
Professor
Document Summary
To save time, executes faster than manual work: macro can eliminate need for human intervention, macro can automate a task you seldom do, allows giving associates, not proficient in excel, hard tasks. Enabling macros: prompts when opening workbooks with macros: do you trust source of macro, opening macro-enabled workbook brings up security content & asks if you want to enable macros. Trust center trusted locations (you can add new ones: if a workbook with macros is placed in a trusted. Location macros are automatically enabled: i. e template folder, xlstart folder. Saving macro-enabled workbooks: save workbook as macro enabled workbook with extension . xlsm. Naming: macro enabled workbook default: macros come disabled, no spaces, must start with a letter, allowed: underscore, letters, numbers. Find and select select current region. Can use existing criteria range or prompt user to input criteria. Storing in personal macro workbook : always in memory & hidden.
