You work as an Office Assistant for Blue well Inc. You want to record a macro and save it with the name "Auto_Open" so that the macro will run whenever you open the workbook containing the macro…

Question

Options

• AThe default workbook or a workbook loaded from the XLStart folder is opened before
• BThe workbook is opened programmatically using the Open method.
• CThe workbook where a user wants to save the Auto_Open macro already contains a
• DThe workbook is based on the record button that is disabled by default before running the

• A
  73% (19)
• D
  27% (7)

Explanation

The various limitations of recording an Auto_Open macro are as follows: 1. If the workbook where a user wants to save the Auto_Open macro already contains a VBA procedure in its Open event, then all actions in the Auto_Open macro are overridden by the VBA procedure used for the Open event. 2. The Auto_Open macro will be ignored when a workbook is opened programmatically using the 3. The Auto_Open macro runs before any other workbooks are opened. Therefore, if the user records actions he wants Excel to perform on the default workbook or a workbook loaded from the XLStart folder, the Auto_Open macro will fail when the user restarts Excel because it runs before the default and start-up workbooks are opened. Answer option D is incorrect. This is an invalid answer option.

No community discussion yet for this question.