DIS 312 Homework 01

Visual Basic for Applications

Name: Score:

1.) (75) Create a macro that adds a left page footer containing your name in bold font on the active page.

Comment out the lines of code that are not needed to perform this task. That is, disable the lines not needed to add your name or make the font appear bold.

Run the macro to make sure it operates correctly.

Note:  when running and debugging this macro make sure you have put data into at least one cell of the worksheet.

Copy and paste the macro code into the space below.

 

2.) (25) Answer the following concerning question 1.

Question:  Why should you “Comment out" the lines of code instead of deleting them?

Answer:

Syllabus