Excel 2007 - UDF always gives #NAME?

[Reljoy]

I've been reading the posts on getting Excel to put a picture into a spreadsheet. However, every time I try to use the function I get a #NAME? error.
I do not get the function name to appear in the Insert Function Wizard.
I have been to the trust center and made sure that the folder I am working in is trusted.
What am I missing?

 

[tusharm]

Um - just discovered that if I protect the sheet, the pictures can't change.
I've tried unlocking the pictures - but as soon as I lock the sheet and try it - I find it doesn't work. When I unlock the sheet again, I discover that the pictures are locked again.
Anyone know how to deal with that?

Don't lock the sheet?

Or unlock it for the duration of the change(s)?