Weird Error 400 problem

[Giordano Bruno]

I have some code which works for me, but gives an Error 400 message to another remote user.
MsgBox 1
ActiveSheet.Unprotect Password:="abc"
MsgBox 2
Range("ShiftMonths").Copy

2 is the last message the user receives before the code fails.
"ShiftMonths" is a range on the active worksheet.

I'm at a loss to understand why if fails for him when it works fine for me.

 

[Yongle]

See what is returned if 2nd message box is replaced with ..

MsgBox 2 & vbCr & ThisWorkbook.Names("ShiftMonths").RefersTo

 

[Giordano Bruno]

Hi Yongle. Many thanks for your reply. As it happens, I have found a workaround for the original problem and no longer have the file in question. Nonetheless, I am intrigued by your check which I have never used before and have stored it away in my 'toolbox'.
Thanks again and best wishes.