Tuesday, July 3, 2012

The Mark as Final Option in Excel 2007


What does Mark as Final do for me?

Mark as Final will make your Workbook a Read Only, similar to the Digital Signature, however, the Digital Signature add another level of security.  The Mark as Final can be removed and then the information changed and then the Mark as Final can be added again.

In order to mark a workbook as final
     1. Click the Microsoft Office Symbol
     2. Hover over the Prepare option
     3. Click the Mark as Final option
     4. A Dialog Box will appear
     5. Click the OK Button
     6. Once you click the OK button a couple of things will happen.
          a. The Workbook will automatically save.
          b. Another Dialog Box will appear, the first time only unless you do not check the “Don’t show this message again” check box.
          c. An Icon will appear in the Status Bar.
          d. The Groups will become grayed out. With the exception of a few options.
          e. The Title Bar will show the words Read Only.

Remember: if you cannot access the options in the groups that you want the Workbook is in the Mark as Final, or read only mode.

To Remove the Mark as Final or Read Only
     1. Click the Microsoft Office Symbol.
     2. Hover over the Prepare option
     3. Click the Mark as Final button; this will have an orange / gold square around it.
     a. After this is done all the buttons in the groups should be active again.

2 comments:

  1. Thanks for explaining this option and clearing out the added advantage that digital signature offers as compared to this option. I will make use of this feature to make my documents read only.
    digital signature

    ReplyDelete
  2. Here is one great creator, writer, technician..friend..read it all staff of Altimex International and give him great reviews..
    I am a great advocate of this super talent..

    ReplyDelete

[Valid Atom 1.0]