Question: BUS 311 Fall 2009 4. Macro: (45 points) a. Set A1 1 so that the only entries will be from the Credit Customer list provided

 BUS 311 Fall 2009 4. Macro: (45 points) a. Set A1

1 so that the only entries will be from the Credit Customer

BUS 311 Fall 2009 4. Macro: (45 points) a. Set A1 1 so that the only entries will be from the Credit Customer list provided in 616 G29. b. Set B1 1 so that the only entries will be from the Product list in G 11 613. c. Set C1 1 so that only positive whole numbrs may be entered. d. Set cells A1 1C1 1 as the only cells the user can change when the sheet is protected. e. Protect this worksheet. f. Create a macro to: i. CopyAllEll. ii. Paste the copied values at the bottom of the "Transaction Log entries without overwriting any previous entry. iii. Clear the content of A1 1 C1 1. iv. Leaves the worksheet protected. g. Place a button on this sheet to run the macro created in step f

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 Finance Questions!