Valid 77-888 Dumps shared by ExamDiscuss.com for Helping Passing 77-888 Exam! ExamDiscuss.com now offer the newest 77-888 exam dumps, the ExamDiscuss.com 77-888 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 77-888 dumps with Test Engine here:
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. While doing so, you observe that the Auto_Open macro fails every time. Which of the following are the causes of this? Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: A,B,C
Explanation/Reference: 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 Open method. 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.
