I did a quick search but I didn't find anything that exactly answered my question.
I just wrote a macro that doesn't really do anything more than add a couple of columns of data with if statements and formats the whole thing to look pretty. It also moves the data sheet to a new file, names it, and saves it.
I would like to break the links to the orginal file so the new file stops asking me if I want to update the links.
What do I need to add to my macro to do that?
TIA,
me
I just wrote a macro that doesn't really do anything more than add a couple of columns of data with if statements and formats the whole thing to look pretty. It also moves the data sheet to a new file, names it, and saves it.
I would like to break the links to the orginal file so the new file stops asking me if I want to update the links.
What do I need to add to my macro to do that?
TIA,
me