Never Mind. I figured it out. I was not saving the code under the
correct private sub.

I was just having a brain fart. Here's what I ended up using.

Private Sub CommandButton1_Click()

ActiveWorkbook.save

End Sub