Microsoft
77-427 · Question #49
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the…
The correct answer is B. Switch to Excel and save the workbook with the .xslm extension as a macro-enabled C. Reopen the workbook. D. Click OK in the message box. See the full explanation below for the reasoning.
Question
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the following lines of code to the procedure: "Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub" Which of the following are the next steps that you will take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.
Options
- AUnder Macro Settings in the Macro Settings category, click Enable all macros, and then
- BSwitch to Excel and save the workbook with the .xslm extension as a macro-enabled
- CReopen the workbook.
- DClick OK in the message box.
How the community answered
(26 responses)- A27% (7)
- B73% (19)
Community Discussion
No community discussion yet for this question.