What can be done to ensure that unauthorized changes are not made to a workbook?

What will be an ideal response?

There are several things that can be done to ensure that unauthorized changes are not made to a workbook. Using the Protect Sheet feature on the REVIEW tab is one step. However you must be sure that you do not protect the sheet to the point a dashboard's form controls or slicers are inoperable. VBA can also be used to secure a workbook by making certain worksheets containing raw data or analysis are hidden and cannot be viewed in the Options dialog boxof Excel. Also, protecting the VBA code with a password is critical for protecting any code from unauthorized changes.

Computer Science & Information Technology

You might also like to view...

CSS was first approved as a standard by the W3C in ______

a. 1996 b. 2002 c. 1992 d. none of the above

Computer Science & Information Technology

What is not a valid requirement for the installation of VirtualBox?

A. The host must have a recent Intel or AMD x86 CPU. B. The host must support hardware virtualization. C. The host must have at least 512 MB of RAM. D. The host must have at least 30 MB disk space.

Computer Science & Information Technology