Chapter 2 Flashcards Preview

Excel VBA COPY > Chapter 2 > Flashcards

Flashcards in Chapter 2 Deck (11)
Loading flashcards...
1

How to display the Developer tab

Right-click Ribbon

Choose customize Ribbon

Put check mark by Developer in second column

2

Shortcut for creating a new empty workbook

Ctrl+N

3

two paths to Visual Basic Editor

Developer->Code->Visual Basic

Alt+F11

4

Shortcut to display Project window in VBE

Ctrl+R

5

how to comment a VBA line of code

precede the statement with an apostrophe ( ' )

6

Shortcut to switch back to Excel from VBE

Alt+F11

7

file extension for macro-enabled file type

.xlsm

8

three malicious things an Excel macro could do

Delete files

Send information to other computers

Destroy Windows so you can't start your computer

9

Shortcut to Help screen

F1

10

Does a workbook containing a macro have to be active to run the macro?

No, it just needs to be open

11

If you store a macro in your Personal Macro Workbook, it is available when?

automatically whenever you start Excel