Mark an Excel File as Complete and Final Version

Add to Favorites
Author: don

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.

Question? Ask it in our Excel Forum


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...