Code to detect / stop certain Excel version from saving

[Grizlore]

Hi All,

I have several Excel spreedsheet which use UserForms with calendar controls.

As Microsoft has removed this from Excel 2010 (version 14?) When such versions open my spreadsheets, it removed the calendar control and makes them unuseable to following Users.

Does anyone know of the code which checks the version number of Excel which has opened the file?

If there is such a thing, I can write some come which prevents those Users from saving the file, and therefore (hopefully) prevent my problems.

Any help appreciated

Regards

 

[VoG]

This returns "14.0" (as a string)

Sub Test()
Dim s As String
s = Application.Version
MsgBox s
End Sub

 

[Grizlore]

Many Thanks Peter

Much appreciated