If I try to give a range the same name as one of my macros from the name box
(at the top left of the workbook) I find I'm suddenly looking at that macro
with my cursor flashing in the VB editor.

Is there any way to stop this or at least capture it as it will confuse
users? Strangely I don't get the same problem if naming from Insert, Name,
Define.

Thanks