Term

Definition

Data validation

A feature that enables you to define a set of rules that guide data entry for a specific range of cells

Digital Certificate

A file attachment that vouches for the authenticity of a macro

Digital Signature

A confirmation that the macro or document created by the signer has not been altered since the digital certificate was created

Input Message

A message on an input box that can provide additional information about the type of data allowed for the cell

Locked Property

A property on a cell that determines whether or not changes can be made to that cell

Macro

A series of commands that are stored and can be run whenever you need to perform the task

Modules

A collection of macros

Name

A word or string of character associated with a  cell or range of cells

Personal Macro Workbook

A hidden workbook, named Personal.xls, opened whenever you start Excel, making its macros available anytime you use Excel

Protect

A feature that allows you to control the ability users have to make changes to the file

Security Level

A means of controlling how Excel handles macros. Security can be high, medium, and low

Sub procedures

A macro in VBA

Validation rule

A rule that defines the parameters by which data is entered into a cell

Visual Basic Editor

A separate application that works with Excel and all of the Office products to edit and manage VBA code

Visual Basic for Applications (VBA)

A programming languages used to create macros