Wednesday, June 27, 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.

1 comment:

  1. I have never used this option so far and is also not aware of it. You have nicely explained the usage of this feature that is provided in Excel which serves benefit similar to what digital signatures offer. Thanks.
    electronic signature Microsoft

    ReplyDelete

[Valid Atom 1.0]