Hi Philip,
I need to do something like this:
#If Application.Version = 11 Then
Application.CommandBars.disablecustomize = True
#End If
the reason is, the desktop pc's are being migrated from Office 2000 to
Office 2003 and I want this code to run if the version is greater then 11
(Office 2002 ?)
The 'disablecustomize' member is not available in Office 2000...
So how can I do this...?
My preference is to late-bind to the Application object to call the
version-dependent stuff:
Dim objApp As Object
Set objApp = Application
If Val(Application.Version) = 11 Then
objApp.CommandBars.DisableCustomize = true
End If
Regards
Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk