How to: Disable file saving in older versions of Excel

Does your company use Excel 2007 and 2003? Did you design a spreadsheet in 2007 with lots of pretty formatting, conditional formatting, IFERRORS, and the likes, only to have someone save the file in Excel 2003 effectively ruining your hard work! Here's the solution I've been using for that;

In the ThisWorkbook object, use the following code:

Please Login or Register  to view this content.

And users simply won't be able to save the file in an older version of Excel. Yay!

You may want to put a warning to that effect on the Workbook_open event though, so they don't do 5 hours of work and end up not being able to save it!

Your users must have the MS office file converter installed, so they will be able to save 2007 format files even in prior versions of Excel - otherwise, they would not have been able to open it in the first place. And they can still save the file if they turn off events.