Excel VBA Excel VBA Automation & Macros

Question 1

Which VBA event fires automatically when a workbook is first opened?

Accepted Answer

Workbook_Open

Answer

Workbook_Start

Answer

Workbook_Load

Answer

Workbook_Activate

Question 2

How do you prevent screen flickering while a VBA macro runs?

Accepted Answer

Application.ScreenUpdating = False

Answer

Application.DisplayAlerts = False

Answer

Application.EnableEvents = False

Answer

Application.Calculation = xlManual

Question 3

Which VBA property disables automatic recalculation during a macro for performance?

Accepted Answer

Application.Calculation = xlManual

Answer

Application.AutoCalc = False

Answer

Application.RecalcMode = xlOff

Answer

Application.FormulaUpdate = False

Question 4

What does the Application.EnableEvents property control?

Accepted Answer

Whether worksheet and workbook event procedures fire automatically

Answer

Whether keyboard shortcuts work

Answer

Whether the macro recorder is active

Answer

Whether add-ins can run code

Question 5

How do you run another macro from within a VBA procedure?

Accepted Answer

Call MacroName or just MacroName

Answer

Exec "MacroName"

Answer

Run.Macro "MacroName"

Answer

Application.RunMacro "MacroName"

Question 6

Which method saves the active workbook in VBA without prompting for a file name?

Accepted Answer

ActiveWorkbook.Save()

Answer

ActiveWorkbook.SaveCopy()

Answer

Workbook.QuickSave()

Answer

Application.Save()