Insert your macro code into a module, start with Sub Auto_Open(). Enter whatever commands you wish to have executed on opening the file and end with End Sub. This will make Excel run macro on open and is the quickest way to run a macro automatically on opening an excel workbook. Excel Run Macro on Open To […]