G'day there Cheesey_toastie,

Application.Goto("ANAME") where the intended named cell didnt exist
ANAME
so instead of erroring it found a function which the orignal developer
had named the same as one of their named cells. Hence the VBA IDE
being launched.

But would't it have gone to the VBE anyway? If there was no
password it would have halted in the VBE with the offending instuction
highlighted and an error message showing there. If the client had filled
in the password, that's what they would have been presented with.

I just tried it myself by using a named range and sub with the
same name. After deleting the name I simply got a Method "Range" of
object "_Global" error message. After clicking 'debug' on the dialog the
line was highlighted awaiting correction.

I think you'll find it had bugger all to do with the function name
coinciding with the range name.

See ya
Ken