You could change ThisWorkbook to ActiveWorkbook, then store the macro in your Personal.xlsb, that way it's available all the time.