I figured out the issue. Because I had the sheet protected, it was not allowing the macro to run. Can anyone tell me the code to have that macro unprotect the sheet and then run the macro and then protect the sheet again.