Just realized that it should be ActiveWorkbook instead of ThisWorkbook.
But now I'm getting an error that the acitve workbook has been
protected, which it has. How do I add code to a workbook that has a
password?