Question: Woon's plan is that when users click the Add Client button in cell C 1 , the Clients worksheet opens and Excel adds a new,

Woon's plan is that when users click the Add Client button in cell C1, the Clients worksheet opens and Excel adds a new, blank record to the Client table, where users can insert the new client information.
Record a macro to automate the Add Client button as follows:
a. Enable all macros in the workbook (if necessary), and then display the Developer tab on the ribbon.
b. Begin recording a macro stored in this workbook using Add_Client as the name of the macro.
c. Display the Clients worksheet, and then add a new blank record to the end of the Client table.
d. Stop recording the macro.
e. Assign the Add_Client macro to the Add Client button on the Home Page worksheet and then run the Add_Client macro to make sure it inserts a new record at the bottom of the Client table on the Clients worksheet.
 Woon's plan is that when users click the Add Client button

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!