Homework answers / question archive / Assignments assume you’ve run and are familiar with the ANSWER samples

Assignments assume you’ve run and are familiar with the ANSWER samples

Computer Science

Share With

---

Assignments assume you’ve run and are familiar with the ANSWER samples.

Use the Assign_08_Events_Part1 workbook for all the parts of this assignment.

Part 1 – Workbook Open (5 points)

1.            Use the “Log” worksheet to keep a log of each time this workbook is opened:

a.            Add a new Log Entry in the next available row which will record the current date and current time.

b.            Increment the Opened Count by 1.

c.             As this sheet is Protected, you must unprotect the sheet prior to making any changes to it then re-protect the sheet afterwards.

d.            Save the workbook.

e.            As there will be a Save event also coded, you must disable events prior to saving the workbook then re-enable events afterwards.

 

Part 1 – Workbook BeforeSave (5 points)

1.            Prompt the user for a password.

a.            If their password does not match what’s in the Save Password cell of the “Log” sheet, issue a short message and Cancel the Save operation.

b.            If their password does match, do not Cancel the Save operation.

 

Part 1 – Workbook SheetBeforeDoubleClick (5 points)

1.            If the double-click was not performed on the “Math” or “English” sheet, then simply exit and do not Cancel the operation.

a.            Use the Name property of the “Sh” parameter.

2.            If the Target cell is empty, then simply exit and do not Cancel the operation.

3.            If the Target cell is not in the 1st Column, then simply exit and do not Cancel the operation.

4.            Otherwise:

a.            Use the Offset property of the Target cell to copy the information in the row of the Target cell to the corresponding cells of the “Grade” sheet.

b.            Activate the “Grade” sheet.

c.             Cancel the operation.

 

 

Part 1 – Worksheet Change (5 points)

1.            Code this event for the “Log” sheet only.

2.            If Address of Target cell is the same as Address of Save Password cell, then convert what’s in the Save Password cell to uppercase.

3.            Note: Converting to uppercase will trigger this Worksheet Change event!

Part 1 – Worksheet BeforeRightClick (5 points)

1.            Code this event for the “Stats” sheet only.

2.            If the Target cell is empty then simply exit and do not Cancel the operation.

3.            If the Count of Cells in the CurrentRegion around the Target cell is less than five (5), then simply exit and do not Cancel the operation.

4.            Otherwise:

a.            If there are any ChartObjects on the Stats sheet, Delete them.

b.            Add a 3D Clustered Column chart to the Stats sheet:

c.             DataSource is the CurrentRegion of the Target cell.

d.            Cancel the operation.

Part 1 – Worksheet BeforeRightClick (5 points)

1.            Code this event for the “TicTacToe” sheet only.

2.            If the Target cell is empty:

a.            Copy/Paste the green “O” cell into the Target cell.

b.            Remove the “dancing ants” from around the green “O” cell.

c.             Cancel the operation.

3.            If the Target cell is not empty:

a.            Clear the Contents of the Target cell only if it contains an “O”.

b.            Cancel the operation.

Part 1 – Worksheet BeforeDoubleClick (5 points)

1.            Code this event for the “TicTacToe” sheet only.

2.            If the Target cell is empty:

a.            Copy/Paste the green “X” cell into the Target cell.

b.            Remove the “dancing ants” from around the red “X” cell.

c.             Cancel the operation.

3.            If the Target cell is not empty:

a.            Clear the Contents of the Target cell only if it contains an “X”.

b.            Cancel the operation.

Part 1 – Worksheet Activate (5 points)

1.            Code this event for the “TicTacToe” sheet only.

2.            Clear the Contents of the nine (9) TicTacToe Squares