All of the following statements are TRUE about protecting VBA code EXCEPT:
A) It is considered best practice to export any VBA modules as text files before protecting them with a password.
B) Before a worksheet is protected, ensure that cells that need to be allowed to be changed to use the dashboard are not locked.
C) Some managers may need to access the raw data in a workbook and should know VBA to be able to unhide those worksheets.
D) Protecting worksheets from intentional or unintentional modification can be done by hiding the worksheets in the Excel workbook.
Correct Answer:
Verified
Q35: A container for code is called a
Q36: A _ performs an action on your
Q37: There are two primary types of procedures
Q38: All of the following statements are TRUE
Q39: The _ allows you to check and
Q41: The Properties window contains a list of
Q42: A Sub procedure performs an action on
Q43: Methods are attributes of an object that
Q44: Slicers are visual controls that allow you
Q45: A particular object can be referenced inside
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents