Do files with Macros have to keep the same filename?

If they do, that makes sense. I've seen myself get confuzzled when if I Save As>different name.