I am runnig a private sub to start a macro (Format) that formats and saves a file. After the file is saved, the private sub is still part of the new file and when it opens up, the formatting macro (Format) runs, messing everything up. Can I put some code in the private sub or the formatting macro (Format) to stop the private sub macro from running once I save the file as something else?