Term
|
Definition
| A set of instructions that execute a sequence of commands to automate repetitive or routine tasks. |
|
|
Term
|
Definition
| A partially completed workbook that you use as a model to create other workbooks that have the same structure & purpose. |
|
|
Term
|
Definition
As a default, all cells are locked as indicated by the orange border around the padlock icon for the Lock Cell option on the Format menu in the Cells group on the Home tab.
Before protecting the worksheet, you should unlock the cells that you want users to be able to edit.
Select the cells in which you want users to be able to enter or edit data.
Click the Home tab, then click Format in the Cells group.
Select Lock Cell in the Protection section to unlock the active cell or selected range of cells
|
|
|
Term
|
Definition
| The first tab on the top left hand side of the screen. |
|
|
Term
|
Definition
Protecting the template is typically the final step in the creation of a custom template because you need to enter standard labels, create formulas, and unprotect input cells first.
Type a password in the Password to unprotect sheet box, then click ok. Confirm Password dialog box opens. Type the same password in the Reenter password to proceed box.
Read the caution statement, then click ok.
Passwords can be up to 255 characters, including letters, numbers, & symbols. It is case sensitive.
|
|
|
Term
|
Definition
Excel Macro-Enabled Workbook |
|
|
Term
|
Definition
Found under the View tab, click Macros in the Macros group, then select Stop Recording.
Click the Developer tab, then click Stop Recording in the Code group.
Click Stop Recording on the status bar.
|
|
|
Term
|
Definition
Macros records the cells as absolute references. When you run the macro, the macro executes commands on the absolute cells, regardless which cell is the active cell.
If you want flexibility in that commands are performed relative to the active cell, click the Macros arrow in the Macros group on the View tab, then select Use Relative References before you perform the commands. |
|
|
Term
|
Definition
| When displayed, provides more in-depth tools that workbook developers use. The Code group contains 2 of the same commands as the Macros arrow on the View tab, but it also includes commands to open the Visual Basic editor & set macro security. This tab also includes Add-Ins, Controls, XML, & Modify groups. |
|
|
Term
|
Definition
By default, Excel automatically disables the macros & displays a security warning that macros has been disabled.
Turned off or stoped. |
|
|
Term
|
Definition
Click Enable Content to use the workbook & run macros.
Start. |
|
|
