yyyy format.

Type 8:10 am in cell E5 and 9:30 am in cell F5.

Type Delayed in cell G5 and 55 in cell H5.

Select cell A5 and click the Apply Fill button.

Click the Apply Fill button as many times as necessary to apply fill color to the odd-numbered rows up to and including row 27.

Save the Excel workbook named your.name.BoydAir-08, for grading in SIMnet (Figure 8-42). Click Yes in the message box saying “The following features cannot be saved in macro-free workbooks: VB project”.
NOTE: When a macro from another workbook is assigned to a form control, a link is created between the other workbook (BoydAirMacros-08) and the current workbook (your.name.BoydAir-08). After saving and closing the files, if you wish to reopen and edit the project files, remember to open both the your.name.BoydAir-08.xlsx and BoydAirMacros-08.xlsm files. When a dialog warning appears, click Update or Enable Content to update links.

Upload and save your (*.xlsx) project file.

Submit project for grading.

– Essay Answers | www.essayanswers.org

January 15, 2023/in www.essayanswers.org /by Admin

please answers these questions csis 110 6

please answers these questions and follow the instructions

VIEW:

Guided Project 8-1

Windows Mac

Boyd Air uses a macros-only workbook and a related template. You edit and record macros in the macros-only workbook. In the template, you record a macro and assign it to a Button form control.

[Student Learning Outcomes 8.1, 8.2, 8.3, 8.4, 8.5, 8.6, 8.7]

Files Needed: BoydAir-08.xlsx (Available from the Start File link.) and BoydAirMacros-08 (Available from the Resources link.)

Completed Project File Names: [your name]-BoydAir-08.xlsx

Skills Covered in This Project

Set macro security options.
Use a macros-only workbook.
Edit a macro in the Visual Basic Editor.
Record macros.
Run macros.
Record a macro with relative references.
Save a macro-enabled template.
Assign macros to Button form controls.

Figure 8-37 Workbook includes macros and documentation

Open the BoydAir-08 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
Set macro security and display the Developer tab.
1. Click the Options command [File tab] and click Trust Center in the left pane.
2. Click the Trust Center Settings button and click Macro Settings in the left pane.
3. Verify or select Disable all macros with notification and click OK.
4. Click Customize Ribbon in the left pane, display the Developer tab, and close Excel Options.
Open the BoydAirMacros-08 file downloaded from the Resources link. This file is an Excel macro-enabled workbook (Figure 8-37). Click the Enable Content button.
Return to the your.name.BoydAir-08 workbook opened at the beginning of the project.
Run and edit a macro to insert todayâ€™s date.
1. Press Ctrl+Shift+D to run the InsertDate macro. Todayâ€™s date displays in cell E1.
2. Delete the contents of cell E1 and press Ctrl+Home.
3. Click the Macros button [Developer tab, Code group].
4. Verify that the ‘BoydAirMacros-08.xlsm’!InsertDate macro name is selected and click Edit to open the Visual Basic Editor (VBE) window. (If the Code window is not displayed, select Module1 in the Project Explorer pane and then choose Code from the View menu.)
5. Click between the â€œHâ€ and the â€œ1â€ in the second comment line and type 3 so that the address is H31 as the cell reference.
  
  Figure 8-38
  Edited code for the macro
6. Edit the code Range(â€œE1â€).Select to show H31.
7. Edit the last line of code to show H32 instead of â€œE2â€ (Figure 8-38).
8. Click the Close button at the top-right corner of the VBE window.
9. Click the Macros button [Developer tab, Code group].
10. Verify that ‘BoydAirMacros-08.xlsm’!InsertDate is selected and click Run. The date displays in cell H31.
Record a macro to insert text.
1. Click the Record Macro button [Developer tab, Code group].
2. Type DateText in the Macro name box.
3. Click the Shortcut key box, press Shift, and type t.
4. Verify or choose This Workbook in the Store macro in box.
5. Click the Description box, type Insert date text, and click OK.
6. Select cell G31.
7. Click the Align Right button [Home tab, Alignment group].
8. Type This report was run on and press Enter.
9. Click the Stop Recording button to the right of the Ready indicator in the Status bar. The ScreenTip for the button is A macro is currently recording. Click to stop recording.
10. Delete the contents of cells G31:H31.
Record a macro with relative references.
1. Click the Use Relative References button [Developer tab, Code group] to enable the command.
2. Select cell A5 and click the Record Macro button [Developer tab, Code group].
3. Type ApplyFill in the Macro name box.
4. Click the Shortcut key box, press Shift, and type f.
5. Verify or choose This Workbook in the Store macro in box.
6. Click the Description box, type Apply fill color to current row, and click OK.
7. Select cells A5:H5.
8. Click the Fill Color arrow [Home tab, Font group] and choose Green, Accent 6, Lighter 80% (tenth column).
9. Press Home to return the insertion point to cell A5.
10. Press down arrow two times to place the pointer in cell A7.
11. Click the Stop Recording button to the right of the Ready indicator in the Status bar.
Test the macros.
1. Click the Undo button in the Quick Access toolbar to remove the fill color.
2. Click the Use Relative References button [Developer tab, Code group] to cancel the command.
3. Select cell A6 and press Ctrl+Shift+F to test the ApplyFill macro. The fill applies to the current row.
4. Press Ctrl+Shift+T to test the DateText macro.
5. Press Ctrl+Shift+D to test the InsertDate macro.
6. Clear the fill color from cells A6:H6 and delete the contents of cells G31:H31.
Complete documentation for the macros.
1. Return to the BoydAirMacros-08 workbook. Right-click the Sheet1 worksheet tab and select Move or Copy. Make a copy of the sheet in the your.name.BoydAir-08 workbook opened at the beginning of the project and place it before the FirstQtr sheet.
2. Rename Sheet1 in the your.name.BoydAir-08 workbook as Documentation
3. Select cell B3, type Apply fill color to current row, and press Enter.
4. Type Shortcut: Ctrl+Shift+F in cell B4.
5. Complete documentation for the DateText macro in cells A9:B10 as shown in Figure 8-39.
  
  Figure 8-39
  Documentation for the macros
6. Press Ctrl+Home.
Click the Save button in the Quick Access toolbar in the BoydAirMacros-08 file to resave the macros only workbook. IMPORTANT: Do not close your macro workbook.
Return to the your.name.BoydAir-08 workbook opened at the beginning of the project and click the FirstQtr worksheet tab.
Assign macros to Button form controls.
1. Click the FirstQtr sheet if it is not already selected. Click the Insert Controls button [Developer tab, Controls group].
2. Click the Button (Form Control) command in the Form Controls category.
3. Draw a Button control that covers cells J4:K4.
4. Select DateText in the Assign Macro dialog box and click OK (Figure 8-40).
  
  Figure 8-40
  Macros are in the macros-only workbook
5. Right-click the Button control and choose Edit Text.
6. Delete the default text and type Date Text as the label.
7. Right-click the control and choose Exit Edit Text.
8. Click the Insert Controls button [Developer tab, Controls group] and select the Button (Form Control) command.
9. Draw a second Button control that covers cells J7:K7.
10. Select ‘BoydAirMacros-08.xlsm’!InsertDate in the Assign Macro dialog box and click OK.
11. Right-click the control and choose Edit Text.
12. Delete the default text and type Date.
13. Right-click the control and choose Exit Edit Text.
14. Draw a Button control that covers cells J10:K10 and assign the ApplyFill macro. Edit the button text to Apply Fill.
Size and align Button form controls.
1. Click cell J2 to deselect the controls.
2. Right-click the Date Text button to display its selection handles.
3. Press Ctrl and right-click the Date control and then right-click the Apply Fill control. Three controls are selected.
4. Click the Align button [Drawing Tools Format tab, Arrange group] and select Align Left.
5. Click the Height box [Drawing Tools Format tab, Size group] and type 0.25.
6. Click the Width box [Drawing Tools Format tab, Size group], type 1.25, and press Enter (Figure 8-41).
  
  Figure 8-41
  Button controls aligned and sized
7. Click cell J2 to deselect the controls.
Select and delete the data in cells A5:A27 and E5:H27.
Select cell A5.
Run macros.
1. Click the Date Text button control.
2. Click the Date button control. Widen column H as needed to display the date.
3. Select cell A5 and type yesterdayâ€™s date in mm/dd/yyyy format.
4. Type 8:10 am in cell E5 and 9:30 am in cell F5.
5. Type Delayed in cell G5 and 55 in cell H5.
6. Select cell A5 and click the Apply Fill button.
7. Click the Apply Fill button as many times as necessary to apply fill color to the odd-numbered rows up to and including row 27.
Save the Excel workbook named your.name.BoydAir-08, for grading in SIMnet (Figure 8-42). Click Yes in the message box saying “The following features cannot be saved in macro-free workbooks: VB project”.
NOTE: When a macro from another workbook is assigned to a form control, a link is created between the other workbook (BoydAirMacros-08) and the current workbook (your.name.BoydAir-08). After saving and closing the files, if you wish to reopen and edit the project files, remember to open both the your.name.BoydAir-08.xlsx and BoydAirMacros-08.xlsm files. When a dialog warning appears, click Update or Enable Content to update links.
Upload and save your (*.xlsx) project file.
Submit project for grading.

Place your Order Now

Step-by-step solutions. Top grades guaranteed.

https://essayanswers.org/wp-content/uploads/2022/11/Essay-Writers-300x52.png 0 0 Admin https://essayanswers.org/wp-content/uploads/2022/11/Essay-Writers-300x52.png Admin2023-01-15 08:34:502023-01-15 08:34:50

please answers these questions and follow the instructions

VIEW:

Guided Project 8-1

Windows Mac

Boyd Air uses a macros-only workbook and a related template. You edit and record macros in the macros-only workbook. In the template, you record a macro and assign it to a Button form control.

[Student Learning Outcomes 8.1, 8.2, 8.3, 8.4, 8.5, 8.6, 8.7]

Files Needed: BoydAir-08.xlsx (Available from the Start File link.) and BoydAirMacros-08 (Available from the Resources link.)

Completed Project File Names: [your name]-BoydAir-08.xlsx

Skills Covered in This Project

Set macro security options.
Use a macros-only workbook.
Edit a macro in the Visual Basic Editor.
Record macros.
Run macros.
Record a macro with relative references.
Save a macro-enabled template.
Assign macros to Button form controls.

Figure 8-37 Workbook includes macros and documentation

Open the BoydAir-08 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
Set macro security and display the Developer tab.
1. Click the Options command [File tab] and click Trust Center in the left pane.
2. Click the Trust Center Settings button and click Macro Settings in the left pane.
3. Verify or select Disable all macros with notification and click OK.
4. Click Customize Ribbon in the left pane, display the Developer tab, and close Excel Options.
Open the BoydAirMacros-08 file downloaded from the Resources link. This file is an Excel macro-enabled workbook (Figure 8-37). Click the Enable Content button.
Return to the your.name.BoydAir-08 workbook opened at the beginning of the project.
Run and edit a macro to insert todayâ€™s date.
1. Press Ctrl+Shift+D to run the InsertDate macro. Todayâ€™s date displays in cell E1.
2. Delete the contents of cell E1 and press Ctrl+Home.
3. Click the Macros button [Developer tab, Code group].
4. Verify that the ‘BoydAirMacros-08.xlsm’!InsertDate macro name is selected and click Edit to open the Visual Basic Editor (VBE) window. (If the Code window is not displayed, select Module1 in the Project Explorer pane and then choose Code from the View menu.)
5. Click between the â€œHâ€ and the â€œ1â€ in the second comment line and type 3 so that the address is H31 as the cell reference.
  
  Figure 8-38 Edited code for the macro
6. Edit the code Range(â€œE1â€).Select to show H31.
7. Edit the last line of code to show H32 instead of â€œE2â€ (Figure 8-38).
8. Click the Close button at the top-right corner of the VBE window.
9. Click the Macros button [Developer tab, Code group].
10. Verify that ‘BoydAirMacros-08.xlsm’!InsertDate is selected and click Run. The date displays in cell H31.
Record a macro to insert text.
1. Click the Record Macro button [Developer tab, Code group].
2. Type DateText in the Macro name box.
3. Click the Shortcut key box, press Shift, and type t.
4. Verify or choose This Workbook in the Store macro in box.
5. Click the Description box, type Insert date text, and click OK.
6. Select cell G31.
7. Click the Align Right button [Home tab, Alignment group].
8. Type This report was run on and press Enter.
9. Click the Stop Recording button to the right of the Ready indicator in the Status bar. The ScreenTip for the button is A macro is currently recording. Click to stop recording.
10. Delete the contents of cells G31:H31.
Record a macro with relative references.
1. Click the Use Relative References button [Developer tab, Code group] to enable the command.
2. Select cell A5 and click the Record Macro button [Developer tab, Code group].
3. Type ApplyFill in the Macro name box.
4. Click the Shortcut key box, press Shift, and type f.
5. Verify or choose This Workbook in the Store macro in box.
6. Click the Description box, type Apply fill color to current row, and click OK.
7. Select cells A5:H5.
8. Click the Fill Color arrow [Home tab, Font group] and choose Green, Accent 6, Lighter 80% (tenth column).
9. Press Home to return the insertion point to cell A5.
10. Press down arrow two times to place the pointer in cell A7.
11. Click the Stop Recording button to the right of the Ready indicator in the Status bar.
Test the macros.
1. Click the Undo button in the Quick Access toolbar to remove the fill color.
2. Click the Use Relative References button [Developer tab, Code group] to cancel the command.
3. Select cell A6 and press Ctrl+Shift+F to test the ApplyFill macro. The fill applies to the current row.
4. Press Ctrl+Shift+T to test the DateText macro.
5. Press Ctrl+Shift+D to test the InsertDate macro.
6. Clear the fill color from cells A6:H6 and delete the contents of cells G31:H31.
Complete documentation for the macros.
1. Return to the BoydAirMacros-08 workbook. Right-click the Sheet1 worksheet tab and select Move or Copy. Make a copy of the sheet in the your.name.BoydAir-08 workbook opened at the beginning of the project and place it before the FirstQtr sheet.
2. Rename Sheet1 in the your.name.BoydAir-08 workbook as Documentation
3. Select cell B3, type Apply fill color to current row, and press Enter.
4. Type Shortcut: Ctrl+Shift+F in cell B4.
5. Complete documentation for the DateText macro in cells A9:B10 as shown in Figure 8-39.
  
  Figure 8-39 Documentation for the macros
6. Press Ctrl+Home.
Click the Save button in the Quick Access toolbar in the BoydAirMacros-08 file to resave the macros only workbook. IMPORTANT: Do not close your macro workbook.
Return to the your.name.BoydAir-08 workbook opened at the beginning of the project and click the FirstQtr worksheet tab.
Assign macros to Button form controls.
1. Click the FirstQtr sheet if it is not already selected. Click the Insert Controls button [Developer tab, Controls group].
2. Click the Button (Form Control) command in the Form Controls category.
3. Draw a Button control that covers cells J4:K4.
4. Select DateText in the Assign Macro dialog box and click OK (Figure 8-40).
  
  Figure 8-40 Macros are in the macros-only workbook
5. Right-click the Button control and choose Edit Text.
6. Delete the default text and type Date Text as the label.
7. Right-click the control and choose Exit Edit Text.
8. Click the Insert Controls button [Developer tab, Controls group] and select the Button (Form Control) command.
9. Draw a second Button control that covers cells J7:K7.
10. Select ‘BoydAirMacros-08.xlsm’!InsertDate in the Assign Macro dialog box and click OK.
11. Right-click the control and choose Edit Text.
12. Delete the default text and type Date.
13. Right-click the control and choose Exit Edit Text.
14. Draw a Button control that covers cells J10:K10 and assign the ApplyFill macro. Edit the button text to Apply Fill.
Size and align Button form controls.
1. Click cell J2 to deselect the controls.
2. Right-click the Date Text button to display its selection handles.
3. Press Ctrl and right-click the Date control and then right-click the Apply Fill control. Three controls are selected.
4. Click the Align button [Drawing Tools Format tab, Arrange group] and select Align Left.
5. Click the Height box [Drawing Tools Format tab, Size group] and type 0.25.
6. Click the Width box [Drawing Tools Format tab, Size group], type 1.25, and press Enter (Figure 8-41).
  
  Figure 8-41 Button controls aligned and sized
7. Click cell J2 to deselect the controls.
Select and delete the data in cells A5:A27 and E5:H27.
Select cell A5.
Run macros.
1. Click the Date Text button control.
2. Click the Date button control. Widen column H as needed to display the date.
3. Select cell A5 and type yesterdayâ€™s date in mm/dd/yyyy format.
4. Type 8:10 am in cell E5 and 9:30 am in cell F5.
5. Type Delayed in cell G5 and 55 in cell H5.
6. Select cell A5 and click the Apply Fill button.
7. Click the Apply Fill button as many times as necessary to apply fill color to the odd-numbered rows up to and including row 27.
Save the Excel workbook named your.name.BoydAir-08, for grading in SIMnet (Figure 8-42). Click Yes in the message box saying “The following features cannot be saved in macro-free workbooks: VB project”.
NOTE: When a macro from another workbook is assigned to a form control, a link is created between the other workbook (BoydAirMacros-08) and the current workbook (your.name.BoydAir-08). After saving and closing the files, if you wish to reopen and edit the project files, remember to open both the your.name.BoydAir-08.xlsx and BoydAirMacros-08.xlsm files. When a dialog warning appears, click Update or Enable Content to update links.
Upload and save your (*.xlsx) project file.
Submit project for grading.

– Essay Answers | www.essayanswers.org

VIEW:

VIEW:

You might also like

Ways of the World with Sources, Volume 2, 4th Edition – 180 Day Option

The Adverse Impacts of Disasters on Homeless People in the United States and the Difficulty of Preparing them for Emergencies