Question:
Does the following work on non-English versions of Excel?
Sub Test()
If TypeName(ActiveSheet) = "Worksheet" Then
MsgBox "The active sheet is a worksheet"
End If
End Sub
Secondly, how can one identify a non-english version of Excel? My approach
has been to check the last menu name on the worksheet menu, and if it is
"Help" then it is an English version.
Answer:
To my knowledge; all foreign versions of excel is also equipped with
english VBA code library, so distributing workbooks with code sheets is
never a problem. So the answer is Yes if You provide the workbook with
the english module, but the code do not cut'n paste into my workbook if
my module language is set to Norwegian.
Submit Your
Own Answer!
