Hello out there
I've got a question regarding the running of macros. I have an icon on my spreadsheet and have assigned a macro to it. The problem is that the macro is only for the filename under which I've saved my file as.
So if I change the filename and click on the icon, the computer searches for the macro in the previous file.
I would like to assign a macro to that icon so that it will run the macro of that name from whichever file is opened at the time.
Does this make any sense?!
Let me know if you get the hang of what I'm on about.
Regards,
Mike