Russell Harris wrote:
The following code works on all spreadsheets but those that have been in the
USA ?

It fails at the ** line with "unable to set the OnAction Property of the
Text Box Class"

Selection.OnAction = sMMAFILE & "!pr_YE" ******************


If sMMAFILE might have a space in it then you need

Selection.OnAction = "'" & sMMAFILE & "'!pr_YE"


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup