Mark an Excel File as Complete and Final Version

Add to Favorites

This feature allows you to make an Excel file that tells everyone that it is the final version, the completed version.

This is great when you need to send a file to someone while at the same time letting them know that no further changes need to or should be made to the workbook.

Note: this feature does not prevent a user from making changes to the workbook.  It merely informs them that no further changes need to be made.

Steps to Mark a Workbook as Final

  1. Click the File button:
  2. Go to the Info section:
  3. Click the Protect Workbook button and then Mark as Final:
  4. Hit OK on the window that appears:
  5. Depending on your settings another window may open, hit OK on there too:
  6. That's it!

The next time you, or anyone else, open the file, a notification message will appear at the top of the window:

If the user then clicks Edit Anyway and edits and saves the file, it will no longer be marked as final.

Notes

I just want to repeat that this feature does not prevent the editing of a workbook.  It merely tells someone that this is the final version.


Downloadable Files: Excel File

Similar Content on TeachExcel
Export an Excel File to a CSV File
Tutorial: How to export an Excel file to a CSV file (comma separated values file).  This allows you...
Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF
Tutorial: This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Output the Name of the Current Excel Workbook Including Extension - UDF
Macro: Free Excel UDF to display the name of the current Excel workbook, including the workbook e...
Prevent Saving a Workbook under a Different File Name
Macro: This Excel macro prevents the user from saving an excel file or workbook under a diffe...