Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started