Mark An Excel File As Complete And Final Version

Create Account Email: Pass: Pass? Join over 20,000 People! Excel Tips in Your Email Excel Courses Shopping Cart

Empty

View Cart

Forum Tutorials Macros

• Excel Courses
• Projects
• Forum
• Tutorials
• Macros
• Resources
  • Blog
  • Free Excel Courses
  • Excel Video Tutorials
  • Excel Keyboard Shortcuts
• Contact

Excel Tips and Tutorials Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access! View Course Mark an Excel File as Complete and Final Version Edit Add to Favorites Favorited Author: don SALE -> Excel Macro & VBA Course

Course SALE (65%-80% Off)

Excel Courses Online Video Lessons Excel Guides

SALE -> VBA Course

Forms Course

Email Course

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.

Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016 Downloadable Files: Project File Sign-in to download the file.

Question? Ask it in our Excel Forum

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

()

VBA Course - Beginner to Expert

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 yo... 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... Guide to Referencing Other Excel Files with Formulas and Functions Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p... Guide to Creating Charts with a Macro in Excel Tutorial: How to add, edit, and position charts in Excel using VBA. This tutorial covers what to do ... 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...

Subscribe for Weekly Tutorials

BONUS: subscribe now to download our Top Tutorials Ebook!

The link to our top 15 tutorials has been sent to you, check your email to download it!

(If you don't see the email, check your Spam or Promotions folder and make sure to add us as a contact so you get our emails in the future.)

Tutorial Details Excel Version: Excel 2007, Excel 2010, Excel 2013, Excel 2016 Downloadable Files: Project File Sign-in to download the file.

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Video 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

()

Contact | Privacy Policy | Disclaimer | Terms Copyright© 2026 TeachExcel.com