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.
Answer: C
You might also like to view...
What is the output of the following code fragments?
int trial( int& a, int b) { if(b > a) { a=b; return –a; } else { return 0; } } float x=0, y=10,z; z=trial(y,x); cout << z << " " << x <<" " << y << endl; a. –10 0 0 b. 0 10 0 c. 10 0 0 d. 0 0 10
(Simple Encryption Application) This application uses a simple technique to encrypt a number. Encryption is the process of modifying data so that only those intended to receive the data can undo the changes and view the original data. The user inputs in a JTextField the number to be encrypted—this is often called the “plain text” value. The application then multiplies the number by 7 and adds 5 to encrypt the original number—this new value is Tutorial 5 Enhancing the Inventory Application 75 often called the “cypher text” value. The application displays the encrypted number in an uneditable JTextField as shown in Fig. 5.32. A user who receives the encr
a) Copying the template to your working directory. Copy the C:Examples Tutorial05ExercisesSimpleEncryption directory to your C:SimplyJava directory.
b) Opening the template file. Open the SimpleEncryption.java file in your text editor. c) Coding the encryptJButtonActionPerformed event handler. Scroll to the event
handler encryptJButtonActionPerformed (lines 98–101). Insert a statement that
gets the number in the enterJTextField, converts the number to an int and assigns the value to int variable plainText. Next, insert a statement that multiplies the number stored in variable plainText by 7 and adds 5, then stores the result in int variable cypherText. Finally, insert a statement that displays the value of cypher- Text in encryptedJTextField.
d) Clearing the result when a new value is input by the user. Locate the event handler enterJTextFieldKeyPressed (it appears immediately after the event handler encryptJButtonActionPerformed) in the template so
A single point of failure is elements, objects, or part of a system that if it fails can cause the entire system to fail
Indicate whether the statement is true or false
What is the main purpose of a user account?
What will be an ideal response?